
1. Re: Confusing Total Cost Calculation
Amit Kalia Nov 28, 2018 10:32 AM (in response to Mike Ade)You can use the simple calculation field as SUM([Labor Cost])+Sum([Material Cost])+Sum([Service Cost])

2. Re: Confusing Total Cost Calculation
Deepak Rai Nov 28, 2018 10:35 AM (in response to Mike Ade)Try This:
ZN(SUM([Labor Cost]))+ZN(Sum([Material Cost]))+ZN(Sum([Service Cost]))

3. Re: Confusing Total Cost Calculation
Michael Gillespie Nov 28, 2018 10:38 AM (in response to Mike Ade)Hard to tell without seeing your source data and/or the calculations behind each of your "cost" fields, but Tableau is doing exactly what you're telling it to.
There must be NULL values in one of those cost columns. Wrap Labor, Material and Service costs (in Amit's formula) in the ZN() function to convert the NULLs to ZEROs. Then your math will work.
In your original calculation you're telling Tableau to return "0" if it finds a NULL anywhere  so it is!


5. Re: Confusing Total Cost Calculation
Mike Ade Nov 28, 2018 10:41 AM (in response to Deepak Rai)This worked! thanks a million

6. Re: Confusing Total Cost Calculation
Deepak Rai Nov 28, 2018 10:42 AM (in response to Mike Ade)Great!!! Please Close The Thread by Marking my Reply as CORRECT. The CORRECT button is under my Reply in your main Thread, not in email.
Thanks
Deepak