Jump to content

Iaron7

Members
  • Content Count

    2
  • Joined

  • Last visited

  1. Thanks for the answer, it does look like using the Triggered Actions loop is the way to get the proper GCD. Im using a little quick and dirty solution for now. Since I wanted this to calculate on the fly, i had to use conditionals within the calcluated field. So if a ratio is 31/130, i divide the divisor by the dividend (130 / 31) and get 4.19 or 1 / 4.19. Now based on what the rounded tenths place of the quotient is, i either: .1 = round down .2 or .5 = multiply dividend and divisor by 5 or 2 respectfully. .3 = multiply by 3 and round up .4 = multiply by 2 a
  2. Any simple way to do this in a calculated field?
×
×
  • Create New...