5 Replies Latest reply on Mar 27, 2015 2:55 AM by thimmaraju.madugundu

    Calculated field not working for dynamical KPI's selection

    thimmaraju.madugundu

      Hi,

      I am creating dashboard using SAP BW (BEX Queries) as data source, when I try to created calculated field it gives error that "Unknown function called SUM".

       

      Am I doing something wrong, I am in the process of creating dynamical selection for KPI's.

       

      IF [Display Selection] ="Sales"  then SUM(Sales)
      ELSEIF [Display Selection] ="Qty" then SUM(Quantity)
      END

       

      I heard that when you use BEX Queries, Aggregate functions will not work (SUM, AVG etc..)

       

      Can any one guide me with right formula.

      Thanks,