7 Replies Latest reply on Feb 28, 2018 12:41 PM by Juhi Srivastava

    count calc divided by LOD Fixed count

    Mac Chadwick Ranier Tolentino

      Hi Guys,


      I have a count calculation, and now I would divide it to the total portfolio:


      Here is the sample calculation:




      ATTR{FIXED [Date , Category]: COUNTD(ID #)}


      -- I've use attr, to satisfy the error "cannot mix aggregated to non-aggregated with this function".

      And the result is null.


      What should be the correct way to write the calculation.


      Thanks in Advance.