Best Practices for FINDITEM on blanks [PLANUAL]

himanshu.badhai
Certified Master Anaplanner

Best Practices for FINDITEM on blanks [PLANUAL]

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

1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

Re: Best Practices for FINDITEM on blanks [PLANUAL]

@himanshu.badhai 

 

Here you go, the updated version:

 

2021-07-27_10-20-29.png

View solution in original post

3 REPLIES 3
rob_marshall
Moderator

Re: Best Practices for FINDITEM on blanks [PLANUAL]

@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
Certified Master Anaplanner

Re: Best Practices for FINDITEM on blanks [PLANUAL]

Figured it might just be a typo. Thank you for updating.
rob_marshall
Moderator

Re: Best Practices for FINDITEM on blanks [PLANUAL]

@himanshu.badhai 

 

Here you go, the updated version:

 

2021-07-27_10-20-29.png

View solution in original post