Fiscal Year Line Chart

[nlaliberte]

Is anyone aware of how to discontinue a line in a chart. I am comparing Fiscal Year 2006 data to Fiscal Year 2007 data in a chart. However when I get to the current month Fiscal Year 2007 (after which there is no more data), the line crashes through the floor and reports zeros instead of just stoping. Does anyone have any suggestions?

 

[lbass]

Try replacing the value you are summarizing with a formula:

if isnull({table.amt}) then
tonumber ({@null}) else
{table.amt}

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

-LB

 

[nlaliberte]

Thanks for the response. I've tried using null values to trick Crystal but the Chart reads the null values as zeros since it trys to convert them to the same type as the other values in the series, which are numbers, and crystal reads null number values as zero.

I was hoping there was some sort of advanced option in the Chart Formatting since this seems like it would be a fairly desirable quality in a chart.

 

[lbass]

No, it will not read nulls as zero--unless you have that set in the report options. Go to file->report options-> and uncheck "convert nulls to default values".

-LB

 

[nlaliberte]

Hey I got it to work. I used a formula like you said but since I already had a use a formula to define the Fiscal Years it took a little trickery with the null values and what not. I had to tinker with the settings too.

Thanks alot for the help.