2 Replies Latest reply on Aug 24, 2017 6:45 AM by Vishal Somani

    Sum certain values based on parameter

    Vishal Somani

      Hi,

       

      I am trying to get something like the below within Tableau:

      There is a parameter for the shortfall column which states that if it results into a positive figure then make it zero. If its negative,   then show the value as the second column.

      i.e. if the target is lower than Act, then make it zero.

      However when I sum the "Grand Total", it shows me a total of £1,400 simply because it recognises the masking done, however calculates the shortfall of the first column to 2, and getting the value of £100.

       

      Can anyone help in identifying how I can only add the negative values?

       

      thanks in advance.

       

       

      ActUnit CostTargetshortfallGrand Total
      10£5080£0
      70£50100-30-£1,500