Skip to Content
1
Former Member
Jul 20, 2016 at 10:01 AM

How to define the "period" and the "current period" in the calculation definition of a KF

918 Views

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