6 Replies Latest reply: Aug 8, 2012 3:18 AM by Dror Svartzman RSS

    AVG and SUM functions reside on the same expression?

    Dror Svartzman

      Hi,

       

      I have set of KPI definition that should be evaluated "on the fly" using dollar expansion and presented in straight table

       

      SOURCE

      KPI:
      LOAD INLINE * [
      [KPI ID], [KPI Definition]
      1, 'AVG([KPI Value])'
      2, 'AVG([KPI Value])'
      3, 'SUM([KPI Value])' 
      ]
      ;
      
      KPIValue:
      LOAD [KPI ID]
               ,[KPI Value]
      RESIDENT KPI_Value; 
      
      

       

      Straight table:

       

      Dimension:

      - KPI ID

       

      Expression:

      $(=[KPI Definition])

       

      Problem: calculation of the expression fails when it try to calculated KPI 3.

       

      Any idea's how i can solve this?

       

      Thanks in advance!