1 Reply Latest reply on Mar 15, 2017 2:51 PM by Patrick A Van Der Hyde

SUM function works, but what happens when I remove a dimension is beyond explanation

Calculated Field is named CO Amount

IF ISNULL([Strip CO Amount])

THEN ZN(FLOAT([Strip CO Amount]))

ELSEIF CONTAINS([Root Cause Details], "Ded")

THEN ZN(FLOAT([Strip CO Amount])*-1)

ELSE FLOAT([Strip CO Amount])

END

Strip CO amount strips the number from a string and then this formula checks if this was an additive or deductive change order

SUM(CO Amount) is the text; I have tried both continuous and discrete with the same results

I don't have the time to recreate the data needed to give an example workbook, but I have pictures of the problems I am seeing.

Here is the breakout with the change order case number.  math works fine here for grand total

when I remove case ID (because I have a dashboard that needs just this view) what in the name of holy heck just happened??  what is it even doing there?  There is no combination of 31286, 33580, -37025.45 that makes 41113.55; not average, not sum, not anything that I can reasonably come up with.

Another problem, the data just disappears when multiple years are chosen:

Single year... messed up sum, but still there

Multiple years.... poof, gone.

Tableau 10.1.5 what are you doing?!

• 1. Re: SUM function works, but what happens when I remove a dimension is beyond explanation

Hello Justin,

I'll provide a few references that may help you with what's going on -  http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#calculations_totals_grandtotal_aggregations.html?Highli…   the online help topic talks about how totals are calculated and the options available by right clicking on the measure and selecting "Totals using ->".   Try changing this to "Sum" as a first step to see if it changes the values here.

But to really help, a small workbook example is needed so that we can see the calculations and filters in use. If you are still stuck on this, even though you said you didn't have the time, I think a number of community members would be able to assist with this.

Thanks

Patrick