Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try the following:
sum({'$(=minstring(Forecast_Period))'} Amount) - sum({'$(=maxstring(Forecast_Period))'} Amount)
Regards.
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
Hi Glenn,
I hope that i have understand your issue. Herewith i have attached an application for your reference.
Regards
Rajeh
Thanks for all replies, everything works fine now.
Rajesh, your file was very helpful. Thank you!
Regards
Glenn