How to calculate forecast deviation

[#1]

Hi,

I would like to calculate the forecast deviation between two forecasts. I have a field called Sales Forecasts that contains several different forcasts 'F1 2010', 'F2 2010', 'F3 2010' with sales data. How do I write an expression to calculate the deviation (eg. F2-F3) given my selection. That is, an expression that subtract the data from one selection from the other one (eg F1-F3)

Thank you

Regards

Glenn

[pover]

Try the following:

sum({'$(=minstring(Forecast_Period))'} Amount) - sum({'$(=maxstring(Forecast_Period))'} Amount)

Regards.

[#3]

Hello,

you could try sets, e.g.,

Count( {F1} Sale) - Count( {F3} Sale)

gives count of sales in set or bookmark "F1" - count of sales in set F3.

FYI

Count( {F1-F3} Sale)

counts sales that exist in set F1 but do not exist in F3

Greetings,

Piet

[#4]

Hi Glenn,

I hope that i have understand your issue. Herewith i have attached an application for your reference.

Regards

Rajeh

[#5]

Thanks for all replies, everything works fine now.

Rajesh, your file was very helpful. Thank you!

Regards

Glenn