Is there an ELSE IF or Switch statement in Anaplan

blairvham18

Hello,

 

I am trying to create an IF statement with 3 possible answers. I was able to do it in excel using this formula:

 

IF(C2="SUPPORT",0 IF(C2="BILLABLE",1,IF(C2="FREE",-1)))

 

But I was wondering if there was a way to do it in Anaplan so I can use the conditional formating with text rather than numbers.

 

Thanks

DavidSmith

@blairvham18 

you could use IF xxx THEN xx ELSE IF xxx THEN

But that is not very efficient!!

Do this instead:

1. Create a list containing the three entries (Support, Billable, Free).  I'll call it Choices

2. Create a module dimensioned by 1. above (Choices) called Choice Attributes

3. Add a numeric line item called Formatting Number and enter 0, 1, -1 respectively

4. In your target module ensure that the line item containing ("C2"), is formatted to Choices, let's say it's called Choice Input

5. Your target line item then becomes Choice Attributes.Formatting Number[LOOKUP:Choice Input]

 

I hope that helps

David