9 Replies Latest reply on Jul 19, 2018 2:45 AM by Daivik Mehra

    Unable to perform Sum operation on an Aggregated Calculation

    Daivik Mehra

      Hi Folks!!!

                     I am stuck with an issue with the aggregated calculations.

      I have created a calculation for Cost per Unit on the basis LOD expressions.

      Now I want to make a set for Top 10 and Others based on Cost per Unit.


      Instead of Sum, I am getting Custom. I am getting the correct values for the Top 10 but Others Total value is not coming proper.

      Screen Shot 2018-07-18 at 3.04.08 PM.png

      The following calculation I am using for calculating Top 10 and Others based on the above set.


      IF [Set for Cost per Unit] THEN [Breakup Category2] ELSE "Others" END


      With this calculation, I am getting the Top 10 values correct according to the breakup, but the total is not coming correct for the  Others.


      Thanks in Advance!!!