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
Answers
-
@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.
1 -
Hi @KirillKuznetsov , Thank you for the quick revert. I was not using the decimal values and using the whole number. Silly mistake. 😛
0 -
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
3 -
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.
1
