Minimum common multiple, BUT BACKWARDS!


I need to convert the following:

I insert a number in a record, for example, 155.
I need to convert or divide 155 into multiples of 40, 30 and 5.
That is, I need the following result in a column: (3 + 1 + 1)

3 * 40 = 120
1 * 30 = 30
1 * 5 = 5

Is it possible to get it?

I need it very urgently!


Sure, anything’s possible, however, doing this in a formula field could be pretty dicey. The better [mathematical] approach is to use javascript in a script action that senses the product (field) is empty and performs the computation.

As a string?

Like this?

Hello, I already have the solution … luiggi cuozzo in the forum…(AND AEROTABLISTAS) passed it to me.

Yep, that’s one way to do it if you don’t mind lots of fields.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.