You may want to use
in both calculations.
HI Bruce ,
Use type conversion function like Int() in both places .
I'm a little new to Tableau so could you give me a bit more info?!
Should the calc read as follows now?
INT(SUM([Mobile Entry])-[Existing Players Entries ])
1 of 1 people found this helpful
What does Tableau tell about your fields --
both [is_new_player] and [Mobile Entry] one?
Do you see T/F Icon to the left of each field?
If yes, the calculations would be like this:
// Your First (Outer) Calc
SUM( INT( [Mobile Entry] ) ) - [Existing Players Entries ] )
// Your Second Calc named [Existing Players Entries ]
SUM(IF [is_new_player] = FALSE THEN INT( [Mobile Entry] ) ELSE 0 END)
Hope this helps.
Thanks Yuri, this worked
Bruce, you're welcome.