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

    Calculated field not working for dynamical KPI's selection



      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)


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


      Can any one guide me with right formula.