Highlighted
Community Boss

Planual Explained - Day 19

"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 David’s 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