
1. Re: How To create a calculated field that will give me the total of all numbers.
ShivaRam Chennapragada Jun 27, 2018 10:55 AM (in response to jose hernandez)Try this and let us know if this is what you're looking for,
TOTAL(SUM(ZN([Unknown])+ZN([Female Count])+ZN([Male Count])))
Thanks,.
Shiva.

2. Re: How To create a calculated field that will give me the total of all numbers.
jose hernandez Jun 27, 2018 11:35 AM (in response to ShivaRam Chennapragada)unfortunately I get the following
argument to sum the function cannot be aggregated further

3. Re: How To create a calculated field that will give me the total of all numbers.
ShivaRam Chennapragada Jun 27, 2018 12:09 PM (in response to jose hernandez)If the data is already aggregated, Tableau won't be able to aggregate it further. Can you attach a packaged workbook?

4. Re: How To create a calculated field that will give me the total of all numbers.
Deepak Rai Jun 27, 2018 12:15 PM (in response to jose hernandez)You need an LOD for that. Please attach a simple sample workbook to Help u.
Thanks
Deepak

5. Re: How To create a calculated field that will give me the total of all numbers.
jose hernandez Jun 27, 2018 12:28 PM (in response to Deepak Rai)hey everyone thanks for the help, unfortunately I am unable to attach a workbook at this time.

6. Re: How To create a calculated field that will give me the total of all numbers.
Deepak Rai Jun 27, 2018 12:35 PM (in response to jose hernandez)Try to Use This
{FIXED:SUM({FIXED Gender, Your other Dimension:SUM(Value)})}

7. Re: How To create a calculated field that will give me the total of all numbers.
Deepak Rai Jun 27, 2018 12:52 PM (in response to jose hernandez)
statecity.twbx 355.6 KB


8. Re: How To create a calculated field that will give me the total of all numbers.
jose hernandez Jun 27, 2018 12:54 PM (in response to Deepak Rai)thank you Deepak I still get an error: I tried the following
TOTAL((ZN([UNKNOWN COUNT])+ZN([FEMALE COUNT])+ZN([MALE COUNT]))) but now I get a total of 8640
which is not close 2881
thank you everybody for the help

10. Re: How To create a calculated field that will give me the total of all numbers.
Deepak Rai Jun 27, 2018 1:02 PM (in response to jose hernandez)Do you have some fake data to create this. I would help..only fake similar data

11. Re: How To create a calculated field that will give me the total of all numbers.
jose hernandez Jun 27, 2018 1:03 PM (in response to Deepak Rai)I will try to put it on an excel sheet and will post it.

12. Re: How To create a calculated field that will give me the total of all numbers.
jose hernandez Jun 27, 2018 1:26 PM (in response to jose hernandez)here is the attachment

book1 test.xlsx 50.6 KB


13. Re: How To create a calculated field that will give me the total of all numbers.
Deepak Rai Jun 27, 2018 1:41 PM (in response to jose hernandez)Pl Check
I Hope It Helps. Pl check sheet 7 and 8
If it Helps, Pl mark it Helpful and CORRECT to close Thread
Thanks
Deepak

statecity.twbx 417.9 KB


14. Re: How To create a calculated field that will give me the total of all numbers.
jose hernandez Jun 27, 2018 1:58 PM (in response to Deepak Rai)hey Deepak thanks for your help unfortunately it does not work gives me a wrong number