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?
Thanks
Solved! Go to Solution.
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.
Thanks,
Harsha
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.
Thanks,
Harsha
Hi @Harsha
Anapedia states the syntax is (cell containing text, text to find, starting point) which is what I did.
Is Anapedia incorrect?
Thanks
My bad I was reading the instructions incorrectly
It was just that simple!
Thanks