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)}




          {fixed State, CustomerID : COUNTD(customerid)}


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