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

Accepted answers

All comments

KirillKuznetsov

@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.

PranayG

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

rob_marshall

@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

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.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…