I have a straight forward pie chart but this is escaping me for some reason.

I have a pie chart with 4 fields for data. There will be some instances where one or two of the fields will be zero.

How would a calculation look that would exclude the "zero" data so the pie chart labels don't look bunched together?

I have a bunch of "is empty" or "if"'s in my head but I must be missing the simpler solution.

Thanks in advanced

(see attachment to see what I'm talking about)

I have a bunch of "is empty" or "if"'s in my head but I must be missing the simpler solution.

I don't think so - at least not with your current structure.

I am not sure how your current calculation is for the Labels but I would use this;

If(Labor;"Labor¶";"") & If(Material;"Material¶";"") & If(Equipment;"Equipment¶";"") & If(Subs;"Subs";"")

See the attached example.

Jerry

PieChartTest.fp7.zip

Jerry

Thank you so much. Always great to learn something new.

Dave

The calculation for "Categories Better" could be:

List (

If ( Labor ; "Labor" ) ;

If ( Material ; "Material" ) ;

If ( Equipment ; "Equipment" ) ;

If ( Subs ; "Subs" )

)