Planual Explained - Day 19

Misbah
Misbah
in Modeling

"Rule 2.02-15": Article 2, Chapter 2, and Rule 15 – “FINDITEM on blanks”. “If the list being referenced does not contain blanks, there is no need to check for blanks with IF ISNOTBLANK(List) THEN FINDITEM(List, Text) ELSE BLANK. It goes against PERFORMANCE, NECESSARY elements of PLANS if you wish to go against this rule

Here is how it was done in Pre Planual Era:

Misbah_0-1591274132696.png

Assumption:  Account Text is always going to be NON BLANK.

What is wrong with this method?  Unnecessarily including IF ELSE statement and increasing the load on the engine

 Here is how it should be done in Planual Way:

Misbah_1-1591274132703.png

 

 

Tagged:

Categories