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:

       

      Count

      /

      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.