This content has been marked as final.
Show 4 replies
-
1. Re: Why Tableau automatic merge 2 cells when there is no same Data
Sankarmagesh Rajan Apr 17, 2015 1:13 AM (in response to phuviet.pham)1 of 1 people found this helpfulit works for me.
try to change null to 0.
IIF(ISNULL([Actual] ), 0, [Actual] )
-
2. Re: Why Tableau automatic merge 2 cells when there is no same Data
phuviet.pham Apr 17, 2015 1:22 AM (in response to Sankarmagesh Rajan)Hi Sankar,
in the Dimension i have also "-". i want to convert this String into 0. i tried
INT(IIF( Sale()="-","0",Sale()) ELSE IIF(ISNULL(Sale(),0,Sale()) )
But is was error. Can you please help me to fix this Calculation?. Thanks
-
3. Re: Why Tableau automatic merge 2 cells when there is no same Data
Sankarmagesh Rajan Apr 17, 2015 2:33 AM (in response to phuviet.pham)Hi Try this [Calculation1]
INT(IIF( [Sales]="-","0",[Sales]) )
and then try to add zero
IIF(ISNULL([Calculation1] ), 0, [Calculation1] )
Thanks
sankar
-
4. Re: Why Tableau automatic merge 2 cells when there is no same Data
phuviet.pham Apr 17, 2015 4:00 AM (in response to Sankarmagesh Rajan)Hi Sankar,
I tried this Calculation and it worked:
ZN(INT(IIF( [Sales]="-","0",[Sales]) ))