2 Replies Latest reply on Aug 27, 2013 6:29 AM by jenny.nedrocik

# adding calculated fields together from excel data extract

Hello,

I am having trouble adding 2 calculated fields together within Tableau.  Both of the calculations are using data from the same data source, an excel spreadsheet.

Here are the 2 calculations:

Total 1 Calc:

if CONTAINS([Object Code Short Title],"BUDGET")=false

and STARTSWITH([Object Code Short Title],"BF")=false

and CONTAINS([Object Code Short Title],"INCOME")=false

and STARTSWITH([Object Code Short Title],"INTRA")=false

and STARTSWITH([Object Code Short Title],"MATERIAL")=false

and[Object Code Short Title]<>"PLANT ENCUMB"

and [Object Code Short Title]<>"ENCUMBRAN -BFW"

then

Case [Sub Acct]

when "430" then [System 1 Amount]

when "520" then [System 1 Amount]

when "541" then [System 1 Amount]

when "576" then [System 1 Amount]

when "528" then [System 1 Amount]

when "745" then [System 1 Amount]

when "860" then [System 1 Amount]

when "861" then [System 1 Amount]

when "852" then [System 1 Amount]

when "833" then [System 1 Amount]

when "894" then [System 1 Amount]

else 0

end end *-1

Total 2 Calc:

If [Group Number]<>"8640"

and [Group Number]<>"8640"

and [Group Number]<>"8630"

and [Group Number]<>"8637"

and [Group Number]<>"8643"

and [Group Number]<>"8650"

and [Group Number]<>"2098"

then

If [Sub Acct]="09" or [Sub Acct]="10" or [Sub Acct]="14" or [Sub Acct]="20" then

Case [Object Code]

when "022100" then [System 1 Amount]

when "122108" then [System 1 Amount]

when "122110" then [System 1 Amount]

when "122120" then [System 1 Amount]

when "112322" then [System 1 Amount]

when "113328" then [System 1 Amount]

when "144131" then [System 1 Amount]

when "115534" then [System 1 Amount]

when "116635" then [System 1 Amount]

when "113336" then [System 1 Amount]

when "114443" then [System 1 Amount]

when "117886" then [System 1 Amount]

when "118990" then [System 1 Amount]

when "114385" then [System 1 Amount]

when "115692" then [System 1 Amount]

when "117698" then [System 1 Amount]

when "135466" then [System 1 Amount]

else 0

end

end

end *-1

After creating these calculations, we then tried adding the 2 together to get a total of the 2.

Total both calculation:

[Total 2 Calc]*1+[Total 1 Calc]*1

The "Total both calculation" only returns the value of "Total 2 Calc".

I can't share the workbook, but I'm hoping that someone can provide an easy explanation as to why my "Total both calculation" is not working and if there is a way to add the 2 calculations together.

Thank you!

• ###### 1. Re: adding calculated fields together from excel data extract

Without diving too deep, have you tried sum([Total 1 Calc]) +sum([Total 2 Calc])?

• ###### 2. Re: adding calculated fields together from excel data extract

Alex - Such a simple calculation!  I can't believe I did not try that yet.  It worked!  Thank you very much!

Shawn - I am using the same excel spreadsheet.  Thank you for your response.