Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've a Data file loaded/displayed in a Table Box where Quantity and Amount fields are holding values; but in some rows of these fields, Data are 0 (Zero) which are displaying as "0.00" in the Table Box columns. I want to show these "0.00" values as " " (Blank).
Sample current Table Box output is given in below snap-shot for ready reference:-
How this can be achieved? Any help. Thanks in Advance.
Since a table box does not allow expressions, I reckon you will have to do this in the script.
Something like
if(A=0,'',A) as A;
On the contrary, you can use a straight table for the same purpose. That way you won't have to do it in Script (Not advisable to make a measure as blank.
What you can do is, pull all the required fields in the dimensions and in Expressions say =1. Then in the presentation tab hide the expression field. You will be able to achieve the same granular table as before.
Regards
CJ
Since a table box does not allow expressions, I reckon you will have to do this in the script.
Something like
if(A=0,'',A) as A;
On the contrary, you can use a straight table for the same purpose. That way you won't have to do it in Script (Not advisable to make a measure as blank.
What you can do is, pull all the required fields in the dimensions and in Expressions say =1. Then in the presentation tab hide the expression field. You will be able to achieve the same granular table as before.
Regards
CJ
Thanks CJ29. It's works fine. Thanks for your solution.
Regards.