on 07-20-2016 11:01 AM
Dear community,
Would you please have the pleasure to inform me of how to define the "period" and the "current period" in a calculation definition of a KF?
e.g
IF(period<current_period,adjustedactuals,IF(ISNULL(salesqty),statfcst,salesqty))
Additionally, would you please inform me of a web page or an appendix with all possible expressions/ formula name conventions that I can use in the calculation definition field?
Thank you for your support
Kind regards
Vasilis
Hi,
the expressions and formulas which can be used in IBP can be found in the Model Configuration Guide:
http://help.sap.com/download/ibp/ibp62_model_conf.pdf
BR Anna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anna,
Thank you for your response.
Unfortunately the guide is not so elaborated in terms of available calculation expressions.
Would you personally know how to define the "period" and the "current period" in the calculation definition?
Thank you very much for your time and support
Kind regards
Vasilis
Hi Vasilis,
Depending on the granularity where you need to make the comparison, you may need to use PERIODIDn.
e.g: if("PERIODID3" < "$$PERIODID3CU$$", adjustedactuals,IF(ISNULL(salesqty),statfcst,salesqty))
In my case PERIODID3 corresponds to monthly buckets as I use a weekly time profile.
Regards
Alecsandra
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.