12 Replies Latest reply on Jan 27, 2019 4:53 AM by Zhouyi Zhang

    Addition and Subtraction of Measures Values in Tableau

    Ankur Gupta

      Hi,

       

      I have few measure values. I am trying to add and delete them to show grand total.

       

      ZN(COUNTD([Employee Id])) + ZN(COUNTD([Demand-id-University])) + ZN(COUNTD([Row ID-HiredOpen])) + ZN(COUNTD([Row ID-PipelinePendingApp])) - ZN([Forecast]);

       

      But the formula is not getting executed properly. On certain columns i am getting the correct results versus some are not. Attached is the screenshot.

       

      I cannot do Column Grand total as values are from different dimensions and it doesnot sum up the required measures.

       

      Sorry i cannot attach the file but attaching screenshot of addition of data.

       

      Thanks in advance for your help.

       

      Thanks,

      Ankur