How Nested Formula affect performance

CommunityMember125605

Hi, I want to improve modele performance.

I'm trying to improve IF statement.

 

Here is two statement.

Answer1 : IF A THEN IF B THEN 100 ELSE 50 ELSE 0

Answer2 : IF A AND B THEN 100 ELSE IF A AND NOT B THEN 50 ELSE 0

 

 

The performance of Answer2 is always better than Answer1? 

 

--- 

Another nested Formula affect performance?

This performance was very bad.

POST((POST(x,1),1) 

ryan_kohn

Per Planual rule 2.02-18, breaking up formulas is pretty much always better.

 

Here are two best practice articles I highly recommend:

• Formula Structure for Performance
• Formula Optimization in Anaplan

 

These will help you understand why breaking up formulas is better for performance.