1 Reply Latest reply on May 18, 2015 3:21 AM by Sankarmagesh Rajan

    how to aggregate two windows_sum calculated fields

    Ram K.V

      i have a dashboard with  two data sources blended and having two calculated fields MTDDelivered and  MTDRevenue  ,

      MTDDelivered :-

      IF FIRST()==0 THEN

          WINDOW_SUM(SUM([MTDDelivered]),0,IIF(FIRST()==0,LAST(),0))

      END

      MTDRevenue :-

      IF FIRST() == 0 THEN

          WINDOW_SUM(IFNULL([MTDRevenue], 0), 0, IIF(FIRST()==0, LAST(), 0))

      END

      I want to aggregate(DIV) these two fields. while in the calculation it throwing aggregated error how we can resolve it . Please suggest.