asked on

Crystal Chart Zero Values

Dear All,

I am plotting a crystal chart using a formula.

Example:

If {Table1_.SalesQty}<=8 then {Table1_.SalesQty} else 0

I would like to suppress the zero values in my chart. Please let me know how to set minimum values to the Y axis, so that zero values can be suppressed.

Thanks
Som

Mike McCracken

WHy not just filter them out of the report?

ANother idea would be to group based on the formula
If {Table1_.SalesQty}<=8 then 1 else 0

You could then suppress the grou 0 chart

mlmcc

reachsoma

ASKER

Thanks for your response.

I can't filter these records as it going to affect other report area. I am using the SAP BEx query, so dont want to define any new conditional key figure at query level.

I would like to plot a line chart for last 12 months ( say Apr- May) and not sure how grouping will help in this case.

Thanks
Som

peter57r

If you cannot exclude the values form the main report, and the grouping is not acceptable, then I think your only option is to use a subreport to contain your chart. You can then exclude the unwanted values from the subreport using a record selection rule.

reachsoma

ASKER

Please let me know more details on the grouping approach. I will try to implement this.

Thanks
Som

Mike McCracken

Create the formula I posted above.
Create a group on it
Put the chart in the group header or footer

mlmcc

reachsoma

ASKER

I have four series in my chart. For only one series i am getting zero values.
If i try for conditional grouping on one series, other 3 series values are affecting. It excludes values from the other series based on the group and not displaying the all months data points.

Regards
Som

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial