Skip to main content

Inglés


HI.

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!


THANKS!


Sure, anything’s possible, however, doing this in a formula field could be pretty dicey. The better rmathematical] 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.


Reply