Finditem formula invalid

Highlighted
Contributor

Finditem formula invalid

Hi

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

7 REPLIES 7
Highlighted
Certified Master Anaplanner

Re: Finditem formula invalid

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,

Highlighted
Community Boss

Re: Finditem formula invalid

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.


Nathan Rudman, Anaplan Model Builder
Highlighted
Contributor

Re: Finditem formula invalid

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

Highlighted
Master Anaplanner/Community Boss

Re: Finditem formula invalid

@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.

Misbah_0-1590758484689.png

 

Hope that helps

Misbah

 

 

Highlighted
Master Anaplanner/Community Boss

Re: Finditem formula invalid

@praba71 ,

 

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

 

2020-05-29_08-38-22.png

 

Highlighted
Contributor

Re: Finditem formula invalid

Thanks @rob_marshall   It resolved the issue..

Highlighted
Super Contributor

Re: Finditem formula invalid

hi @praba71 

 

put the list name in single quotes 

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