5 Replies Latest reply on Apr 25, 2018 10:26 AM by Minnu Meena

    % Aggregation Issue

    Minnu Meena

      Hi,

       

      I created a % calculation cal where if i select YTD / MTD / QTD it should work.

      But the calculation throwing error as Aggregation and non aggregation issue.

       

      Can anyone please help me to work this calculation based on selection period.

       

      Below is the calculation throwing aggregation error.

       

      GID % Period is the cal name :

       

      case [Parameters].[Period]

      when "MTD" then IF  ATTR([W Current Mcal Period Code])= "Current" then  ([GID %])  END

      when "QTD" then IF  ATTR([W Current Mcal Qtr Code])= "Current" then  ([GID %]) END

      when "YTD" then IF  ATTR([W Current Mcal Year Code])= "Current" then  ([GID % ])  END

      END

       

      Find the Attached workbook for your reference.

       

      Thanks,

      Minnu.