1 Reply Latest reply on Jan 25, 2019 5:24 AM by Zhouyi Zhang

    Issue with calculation used in caption when totals are enabled

    ovidiu.baciu

      Hello. I defined the following calculation:

      WINDOW_SUM (

          IF (

              RUNNING_SUM(SUM([Duration]) / WINDOW_SUM(SUM([Duration])))

              ) <= [Threshold]/100

              THEN 1

              ELSE 0

          END

      )

      I included the output of the calculation in the sheet caption.

      If totals are disabled, the caption shows a single value, e.g. 3.

      However, if column totals are enabled, the caption shows a range of values, e.g. 0 to 3.

       

      Is there a way of showing the column totals while also displaying a single value in the caption?