FIND Function

Highlighted
Community Boss

FIND Function

Hi Team,

 

I'm using the FIND function for the 1st time & it not working as I expected. 

 

It seems like a basic Function so I must be missing something easy but I would assume that below the value returned in the FIND line item would be 1 as it would find ANZ?

 

IMG1.PNG

 

Thanks

 

3 REPLIES 3
Highlighted
Frequent Contributor

Re: FIND Function

Hi @MarkTurkenburg 

 

FIND function return position of text which you are searching. And also you put wrong syntax in the formula.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/FIND.html

 

FIND(X,Y,N) :: X = "ANZ"/ text to find, Y =Region Text / Text to search in, Z = starting point. 

 

Harsha_D_0-1594616717284.png

Thanks,

Harsha

Highlighted
Community Boss

Re: FIND Function

 

 

Hi @Harsha_D 

 

Anapedia states the syntax is (cell containing text, text to find, starting point) which is what I did. 

 

Is Anapedia incorrect?

 

Thanks

 

 

IMG1.PNG

Highlighted
Community Boss

Re: FIND Function

My bad I was reading the instructions incorrectly

 

It was just that simple!

 

Thanks