Best Practices for FINDITEM on blanks [PLANUAL]

himanshu.badhai
himanshu.badhai
in Modeling

I was going through the PLANUAL and noticed this error. I think the formula is wrong.


If majority items in a list are blank then it should be:

 

  • IF ISBLANK(Line Item) THEN BLANK ELSE FINDITEM(List, line item)

Also, is it efficient to use ISBLANK() in conjunction with FINDITEM() OR a better approach could be using a Boolean?

 

Line Item 1 = ISBLANK(Line Item)

Line Item 2 = IF Line Item 1 THEN BLANK ELSE FINDITEM(List, line item)

 

himanshubadhai_0-1627397440428.png

Tagged:

Best Answer

Comments

  • rob_marshall
    rob_marshall

    @himanshu.badhai 

     

    What are you thinking is wrong with the rule?  What it is basically saying is to check if the line item that you are doing the finditem() on is blank or not.  If it is blank, then don't do the finditem() at all because in doing a finditem() on a blank line item will always return a blank.  So essentially, this is saving the system from reading a list to find nothing.  Does that help?

     

     

    AHHHH....I see and you are correct, I forgot the NOT in ISNOTBlank() or I could turn the formula around and put the finditem() for the ELSE condition.  Great catch, will update that now.

     

    Rob

  • himanshu.badhai
    himanshu.badhai
    Figured it might just be a typo. Thank you for updating.

Categories