1 Reply Latest reply on Feb 22, 2016 12:12 AM by Bora Beran

    Problem in calculating the percent

    Swarup K

      Hello All,

       

      I am facing problem in calculating the non profit customers state wise. Attaching the workbook someone please help me.

        • 1. Re: Problem in calculating the percent
          Bora Beran

          Please remove customerID from your LOD expressions, dimensionality

           

          e.g. if you want to count customerId in each state expression should be

           

          {fixed State : COUNTD(customerid)}

           

          not

           

          {fixed State, CustomerID : COUNTD(customerid)}

           

          the other issue is that you are using COUNT but it looks like you need to use COUNTD.