Finditem formula invalid

praba71

I am trying to use the FINDITEM formula for one of the line item in my module.

Following is the formula used:

Organization Code LF = FINDITEM(OPSdb Site, Organization Code LF). Please refer the screenshots attached.

Any help would be appreciated.

Thanks

Prabakaran

Screenshot_2020-05-29_at_4_72085.png

Accepted answers

rob_marshall

@praba71 ,

Why are you daisy-chaining the calculation, just use comp_reservation_details.Organaization Code as the second parameter.

All comments

MaartenGijbels

Hi @praba71 ,

Are you typing the formula?

I'd add ' before and after the line item. Probably he just gets stuck with the ()'s in your LI-name.

All the best,

nathan_rudman

I believe what you want to do is:

FINDITEM(OPSdb SIte,'Organisation Code(source)')

note the single quotes '

If your line item/list name has a number or a special character, you will need to enclose it with single quotes.

Misbah

@praba71

When you type in your formula make sure you activate the formula bar and write FINDITEM and then point and refer. Anaplan will automatically fill in all the necessary characters.

Hope that helps

Misbah

praba71

Hi @nathan_rudman @MaartenGijbels

Thanks for your response. I tried this formula. FINDITEM(OPSdb Site,’Organization Code (Source)’)

But this is still giving me invalid error.

Regards

Prabakaran

Screenshot_2020-05-29_at_6_72117.png

rob_marshall

@praba71 ,

Why are you daisy-chaining the calculation, just use comp_reservation_details.Organaization Code as the second parameter.

Kanishq17

hi @praba71

put the list name in single quotes

use finditem('list name', text line item)

praba71

Thanks @rob_marshall It resolved the issue..

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…