Hidding Multiple Values

[#1]

Some of my data has two values displayed when I filter on a month-by-month basis. I'm tracking both Actuals and Forecasts, thus for months that have already occurred, Actuals and Forecasts are displayed simultaneously. How can I hide Forecasts if and only if values are present within Actuals?

[swuehl · Accepted solution]

You want to do this in the chart or the script? How do your expressions look like?

Mayb it's enough to filter Forecast expression like

=if("ActualExpression">0, YourForecastExpression)

[#3]

PERFECT!