Omitting Zero Values from Chart

[ProgressiveJL]

Hi All,

Is it possible to set a condition for displaying items on a chart? (ie. omitting zero sum items from the x-axis)

If so, how?

Thanks in advance!

 

[lbass]

Let's say you are using a line chart, and that you are showing values on change of month with a separate line per year. First you would create a formula {@null} where you open a new formula and save and close it without adding anything to the formula area. Then create conditional formulas for the two lines:

//{@lastyear}:
if year({table.date}) = year(currentdate)-1 then {table.amt} else tonumber({@null})

//{@thisyear}:
if year({table.date}) = year(currentdate) then {table.amt} else tonumber({@null})

For the current year, the line will stop at the current month instead of dropping to zero.

-LB

 

[ProgressiveJL]

I'll try this out... You're a superstar LB! =P