Sunday, February 19, 2012

Calculation Fore color test against a percentage fails

I have a calculation which creates a field with a Format string of "Percent". This works fine.

I have a Fore color test which reads

IIf ([Measures].[Avg Capitalisation] > '85%', 65280 /*Lime*/, 255 /*Red*/)

but ALL values are coloured RED. Any clues. I suspect it is in the way I am testing the 85% threshhold.

Thanks, in advance, for any assistance.

IIf ([Measures].[Avg Capitalisation] > 0.85, 65280 /*Lime*/, 255 /*Red*/)

|||

Deepak, thanks that is working now.

Graham

No comments:

Post a Comment