9 Replies Latest reply: Aug 10, 2017 2:46 AM by Sasidhar Parupudi RSS

    Weird behavior in the division operation

    Vishnu Chakravaram



      I have a calculation like this:


      (Both Numerator and Denominator work individually... but their division doesn't work)


      Sum(Aggr(if(Sum([Is Engaged?])/(Count(distinct [Month Year])*4) >= 2,1,0) , [Party ID]))


      Sum(Aggr(1,[Party ID])) // same as Count (distinct [Party ID])

      What I have tried:

      Put numerator and denominator separately in a variable and do the division on variables. Doesn't work

      Use the div function.

      Hoping I didn't do any silly mistake