Calculating values for certain months

[reinholdgraf]

Hi.

I have the following issue:

Actual sales-figures come in by month (January - November 2015).

Forecast-figures are from October - December 2015.

If I now want to show ACTUAL / FORECAST, I must not consider November for actual values, because this is already included in FORECAST.

Could this be done within a sum-formula ?

Regards,

Reinhold

[Gysbert_Wassenaar]

That should be possible. Perhaps sum({<Month={"<10"}>}Actual). I don't know if you have month numbers available. You could also try sum({<Month-={'October 2015','November 2015','December 2015'}>}Actual) if your month field contains that kind of values.