I have to conditional format a crosstab depending upon a revenue, i have string variable
if([Query1].[Revenue])>(1000000) then (' High ') else
if([Query1].[Revenue])<(11000000) then (' Low ')
It is validating fine but report output doesn't show the colors i have applied.
Quoteif([Query1].[Revenue])>(1000000) then (' High ') else
if([Query1].[Revenue])<(11000000) then (' Low ')
Well, let me take you through a bit before getting into the answer.
As per your PDF output, Mountaineering Equipment -> E-mail is 7,476,451.96, this figure is >1000000 and also <11000000. So both the conditions are TRUE(high & low), which resulting no conditional coloring.
If you want all the values between 1000000 and 11000000 should show some color and rests a different color, then your expression should look like below
if([Query1].[Revenue] between 100000 and 1100000)
then (' High ')
else (' Low ')
Hope it helps?
Thanks,Prit.But the expression is not validating and giving me parsing error.
Hi barrysaab,
please explain clearly your exact requirement.we can solve it easily. we are not able to understand your requirement.
thanks
bvk
QuoteBut the expression is not validating and giving me parsing error.
Should work though, anyway have you tried like this?
if([Query1].[Revenue] >= 100000 and [Query1].[Revenue] <=1100000)
then ( 'High')
else ('Low')
Thanks a lot PRIT.It worked!