2 Replies Latest reply on Nov 9, 2012 9:10 AM by chris_capula

    AF 'mod' Maths Function

    chris_capula

      Hi All,

       

      I am trying to use an AF Formula to calculate an Unbalance Percentage. For this reason, I am not interested if it is positive or negative, I just want the value.

       

      I thought the best and most efficient way to do this is to use the 'mod' function, however when I try to use this i get the error 'Math function not found'

       

      Has anyone used this function before within a AF formula and had some success? Or am I going down the wrong path here? I tried the documentation but could only find the order of precedence for math functions.

       

      I have tried a number of variations of the formula for the calculation, including:

       

      (mod(((A+B+C)/3) - C) / ((A+B+C)/300))

       

      mod((((A+B+C)/3) - C) / ((A+B+C)/300))

       

      I have even tried mod(A) where A = -1 but all still the same error.

       

      Any help would be greatly appreciated,

       

      Thanks,

       

      Chris