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