2 of 2 people found this helpful
I think you are dealing with the row-level vs. aggregate level calculations difference again (see our thread from earlier today: http://community.tableau.com/thread/124520)
SUM(IF Ranking > 3 THEN 1 ELSE 0 END)
That wraps a row level calculation inside an aggregate. Or you might want to simplify to this:
IF Ranking > 3 THEN 1 ELSE 0 END
and then just SUM the resulting measure.
Hope that helps!
I used the formula above, and for some reason, instead of getting a '1', I'm getting a '2' entered in my calculation:
Count Function: IF [Rapid Check] <= 2 THEN 1 ELSE 0 END
- Then I applied a Sum to the table calculation
Rapid Check Formula:
IIF([Status Changed To Hold Auth At] > [Asset Checked In At],
DATEDIFF('minute',[Asset Checked In At],[Status Changed To Hold Auth At]),Null)/60
Why am I getting a 2, not a 1? I'm so confused!