Best Practices for FINDITEM on blanks [PLANUAL]

himanshu.badhai

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)

Accepted answers

rob_marshall

@himanshu.badhai

Here you go, the updated version:

All comments

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

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

rob_marshall

@himanshu.badhai

Here you go, the updated version:

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…