4 Replies Latest reply on Oct 29, 2018 7:09 AM by Shinichiro Murakami

    How to calculate a custom table total

    Loz Brooks

      I have a table with forecast values for the current financial year and the actual values up to the current month. What I would like to have is a totals column with standard total for Forecast but for Actual to be YTD plus the forecast figures for the rest of the financial year. i.e. add Forecast values where Actual is null.

       

      Apr 18May 18Jun 18Jul 18Aug 18Sep 18Oct 18Nov 18Dec 18Jan 19Feb 19Mar 19Total
      Actual12141315151613?
      Forecast111515141417141514161414173

       

      I've been playing around with different calculated fields and can't seem to make a single thing work! Thanks in advance.