How to reference a Time Period in an IF statement please?

KillianGavin
KillianGavin
in Modeling
AnaplanQuestion.PNG

My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says

IF Time Period < Jul 19

THEN TEST 1

ELSE TEST 2

How do I reference the Time Period in the IF statement? i.e. how do I write the IF statement so that in the RESULT line item there is 250 from Jan 19 until Jun 19 & 500 from Jul 19 until Dec 19?

Let me know if you require any more information & thanks in advance.

Kind regards,

Killian

Tagged:

Best Answer

  • devrathahuja
    devrathahuja
    Answer ✓

    @KillianGavin - Create a line item in a SYS Lookup module (No dimensions) and specify your "Jul19" parameter there.

    In the final line use the formula if item(time) < above line item then "250" else "500"

Categories