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

    Addition and Subtraction of Measures Values in Tableau

    Ankur Gupta



      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.