How to stop showing one of lines in the middle of graph? 1

[russula]

Hello All!

It is about CR XI. I have graph with Multi-Axes showing two lines. One of these lines goes to the 0 in the middle of graph. It is normal because graph shows Forecast and Actual data and from current_date there is no actual data, only Forecast. At the moment line for actual data falls down to the 0, but it is not correct. I just have to stop showing this line. Is it possible to suppress line in the graph depending on values on the X axis? Something like this:

if {table.month} > month (currentdate) then suppress (?)

Or maybe while calculating actual data it is possible to put NULL instead 0 (I didn't find it in help)?

Is there any solutions?
Thanks in advance for help.

 

[lbass]

Create a formula {@null} by opening and saving a formula without entering anything. Then use a conditional formula for the summary field in your graph:

if {table.month} <= month (currentdate) then
{table.amt} else
tonumber({@null})

You might need to add in the year, depending upon what you are charting.

-LB

 

[russula]

Super! It works! Many thanks, Ibass!

(date comparing is a bit more complex because of some conditions but it is not a problem)