How to apply IF AND function in ANAPLAN

PranayG
Contributor

How to apply IF AND function in ANAPLAN

I have 3 conditional formatting ranges 
• 0-39 RED
•40-89 Yellow
• >90 Green

I am able to return correct values for RED and Green , but what formula do I use to tell the model Yellow is between 40 and 89?

I at the moment used this formula - 
IF Attainment <= 0.39 THEN 0 ELSE IF Attainment >= 40 AND Attainment <= 89 THEN 0.5 ELSE 1

1 ACCEPTED SOLUTION

Accepted Solutions
KirillKuznetsov
Certified Master Anaplanner

@PranayG Could you please share screenshot of conditional formatting setting?

You can set a midpoint in it and enter 0.5 as the midpoint value.

Regards, Kirill Kuznetsov
Advanced, LLC

View solution in original post

4 REPLIES 4
KirillKuznetsov
Certified Master Anaplanner

@PranayG Could you please share screenshot of conditional formatting setting?

You can set a midpoint in it and enter 0.5 as the midpoint value.

Regards, Kirill Kuznetsov
Advanced, LLC
PranayG
Contributor

Hi @KirillKuznetsov , Thank you for the quick revert. I was not using the decimal values and using the whole number. Silly mistake. 😛

rob_marshall
Moderator

@PranayG 

 

Rather than using long IF THEN ELSE statements, give this article a try written by @JaredDolich 

 

https://community.anaplan.com/t5/How-To/Planning-Sales-or-Invoices-Using-Tier-Pricing/ta-p/60614

 

Rob

JaredDolich
Moderator

Thanks @rob_marshall for the shout out.

@PranayG Going back to DISCO, this would be the transformation module or the "C". Prevents the need for a lot of IF THEN.


Jared Dolich