13 Replies Latest reply: Mar 26, 2018 5:27 AM by Finbar Gillen RSS

    COUNT TOTAL (DISTINCT)

    Finbar Gillen

      Hi All,

       

      I am looking to get the percentage the total values within a year. I thought the formula below should work but it doesn't.

       

      Count(DISTINCT{<MONTH_ID = {201701}>}  POLICY_ID) / Count(DISTINCT TOTAL {<MONTH_ID = {201701}>} POLICY_ID)

       

      Anyone have any ideas?

       

      Regards

      Finbar