Performance of Comparision of Boolean using = sign over using NOT function

Pranjal

Whether using

IF Approved? = TRUE THEN 1 ELSE 0

is good or optimizing the formula as

IF Approved? THEN 1 ELSE 0

where "Approved?" is a BOOLEAN format line item.

Same goes for,

IF Approved? = FALSE THEN 1 ELSE 0

IF NOT Approved? THEN 1 ELSE 0

Please advise to optimize performance of the model.

Accepted answers

All comments

ManjunathKN

Hi @Pranjal

Below 2 are optimized way of coding

IF Approved? THEN 1 ELSE 0

IF NOT Approved? THEN 1 ELSE 0

the reason is because you dont need to tell a condition =true or false, since the if else condition is already taking logic.

please find article which will give you right approach of optimization for similar queries : https://community.anaplan.com/t5/Best-Practices/Formula-structure-for-performance/ta-p/33177

Thanks,
Manjunath

luke_e

The other thing to consider with IF loops (and calcs in general) is the concept of an early exit.

Your example is pretty straight forward, but you should try to write your calculations in a way where the most likely occurence is the earliest part of your calculation. Otherwise, the calculation engine has to run through the entire calculation until it either reaches the end, or finds a valid case.

E.g. If there's more occurences of 'Approved' instances, you'd write IF Approved THEN X ELSE Y. Otherwise you'd write it the other way around using IF NOT Approved ...

As I noted, this is more relevant for longer calculations, but you should apply this concept as a best practice where possible.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385