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

    Weird behavior in the division operation

    Vishnu Chakrakishore

      All,

       

      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


      stalwar1