Finditem formula invalid
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.
Why are you daisy-chaining the calculation, just use comp_reservation_details.Organaization Code as the second parameter.0
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,0
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.0
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.
Thanks @rob_marshall It resolved the issue..0