8 Replies Latest reply on Feb 22, 2016 5:19 AM by Hrvoje Gabelica

    Combined Grand Total

    Lindsey Abot

      Hi all,

       

      I'm using calculation below to differentiate Actual or Forecast BUT now my Grand Total is no longer a proper Grand Total.

       

      I'm trying to get my Grand Total row to show the value of 1,307 - which is 893 + 414.

       

      Calculation:

      IF [Full Date] >= [Today] THEN 'Forecast'

      ELSE 'Actual'

      END

      Combined Grand Total.JPG

       

      Appreciate all the help I can get.

       

      Cheers,

      Lindsey