4 Replies Latest reply on Apr 2, 2014 9:56 PM by srinivas kumar

# doubts in conitional color formatting

I have a doubt in conditional color formatting ,Why we are using the calculated fields 0 which consists formula '0' and 1 which consists of formula '1'.

Will u please explain me pls for reference am sharing the worksheet image

• ###### 1. Re: doubts in conitional color formatting

Hi Srinivas,

I didn't understand why you created those two calculated fields. I think you are trying to achieve conditional formatting in worksheet. Can you explain what you want exactly? did you get your requirement in that sheet? If possible try to explain your doubt with a sample workbook it will very helpful for understanding problem

• ###### 2. Re: doubts in conitional color formatting

Hi venkat,

Actually i followed the steps from Internet itself.Task is accomplish but i have the doubt why they are using the calculated fields

• ###### 3. Re: doubts in conitional color formatting

The sum(0.0) pill is used to create a "multiple axis crosstab" as described at this link:

http://public.tableausoftware.com/profile/#!/vizhome/conditionalformattingv4/BuildingtheMultipleAxisCrosstab

The max(1.0) is used on the Size shelf to fill the entire contents of a "pane".

However, for this example you don't need to use a multiple axis crosstab--this conditional formatting can be accomplished without it for a single dimension and value.  You can remove the SUM(0.0) pill from the view, and you should be able to get the results you want.

1 of 1 people found this helpful
• ###### 4. Re: doubts in conitional color formatting

Thanks Mattew,

Even i try without sum(0.0), i got the solution. If i want to do color formatting for more than one column then sum(0.0) is prefrred right.

will you please clarify this doubt.

and one more thing we can also use min(1.0) in place of max(1.0).I didnt find any difference.

Will you please explain is there any difference in between min(1.0) and max(1.0) in size shelf.

Thanks Alot Mattew