Crosstab Cell formatting

[emcevoy]

looking for some help here.
Have a crosstab

rows Column year
TypeSort (showing type) Year
CatagorySort (showing Catagory)

Summary fields
Sum(Formula)

this works great, however what I want to do is based on the catagory I want to format the summary field decimal places. for example, if the last 7 characters are percent, then I want 2 decimals if it is not then no decimals.

I can format one way or the other but never can get the summary field formatting formulas to see that the catagory is percent.

any ideas? please let me know if you need further verification on this. I am desparate.

thanks all!

Eileen

 

[lbass]

Please do not crosspost.

-LB