Skip to main content

Minimum common multiple, BUT BACKWARDS!

  • November 10, 2020
  • 4 replies
  • 35 views

Forum|alt.badge.img+3

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!

4 replies

Forum|alt.badge.img+19
  • Inspiring
  • November 10, 2020

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?


Forum|alt.badge.img+3
  • Author
  • Inspiring
  • November 12, 2020

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


Forum|alt.badge.img+3
  • Author
  • Inspiring
  • November 12, 2020


Forum|alt.badge.img+19
  • Inspiring
  • November 12, 2020


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