3 Replies Latest reply on Nov 27, 2016 6:07 PM by Nachiket Dekhane

    Hi This is Preeti Dhanerwal

    Preeti Dhanerwal

      I am facing an problem in calculating the result for KPI values. I am using this formula

       

      IF(DENOMINATOR>0 then (NUMERATOR/DENOMINATOR) else NUMERATOR)

      END

       

      But getting an error for not mixing aggregate and non aggregate function.

       

      Can anyone please tell me an alternative to run this .

       

      Attach is the sample data.

       

      Please see the result1 formula. I am also attaching the excel version which should be duplicated into Tableau. Data should be match in both Excel Pivot and Tableau (unfortunately not)

       

      Please help its really urgent.