Need help with Graph........

[LHSCNaved]

Hi All,

VS2008/CRXI/SQl server 2005.

I have created a quarter wise report for the Board and different committees of the Board. For each indicator or measure we represent the results and targets for five quarters. Now the management does not want to see the targets
values for the year 2009.
I took the following steps to meet the requirement.

First Step:
Created the first formula @CustomeTarget as which works fine.
if mid({@FiscalQtrShort},1,2) = "09" then
0
else
{Reports.Target}

Second step:
Suppressed the the target value in Cross tab like this.
if currentfieldvalue = 0.00 then true else false works great.

At the graph level we can still see the target line at 0 as the @CustomeTarget have values in zeros.

Is there a way I can suppress the target line only for the year 2009 ?

Thanks a lot in advance.

 

[lbass]

Try replacing the 0 in your formula with:

tonumber({@null})

...where {@null} is a new formula that you open and save without entering anything.

-LB

 

[LHSCNaved]

Thanks LBass, Worked perfectly.