8 Replies Latest reply on Jun 26, 2018 11:58 PM by Mavis Liu

    Total sum is not correct

    Ana Ana

      Hello everybody,

      I am having trouble with the total sum in the project I am working in.

       

      I have this calculated filed in measures:

      IF SUM([Sales])>0 THEN ([Sales])
      ELSE ([Budgeted Sales])

      END

       

      I would like to show for every day of the month either the sales that were done, either the budgeted sales ( starting today I have no sales yet).

      Every day I have the correct numbers. But when I add the total, it ads up just the sales. (I believe tableau just looks at the global picture, and sees that I have sales that month and gives me the first part of the formula)

       

      Do you have any suggestions for me ? I would like for it just to add the rows that represent every day of the month.

       

      Thank you in advance for your answer.