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!!!