12 Replies Latest reply: May 29, 2017 2:02 PM by Dafnis X RSS

    Getcurrentfield in TOTAL expression

    Dafnis X


      My bar chart has 2 dimensions:

      1.periods - cyclic selection

      2. metric code (1-4)


      1.bar - order quantity

      2.text - average duration of all segments for the current period (e.g., date)


      I need to display an average for each column, according to a selected cyclic dimension.

      But the following expression doesn't work, as all the values are the same.


      sum(TOTAL <$(='[' & GetCurrentField([Cyc_SaleOrd_Periods]) & ']')> Order_OpenTarget_TimeDiff)

      /count(TOTAL <$(='[' & GetCurrentField([Cyc_SaleOrd_Periods]) & ']')>  DISTINCT  SaleOrder_ID)


      Would appreciate another way to display it...






      Message was edited by: Dafnis X Attached sample data