Find formula

Sravan_Kumar · April 2020

Hi Friends,

Do we have any special formulas for the below calculation.

Misbah · April 2020

Create additional Line item to find delimiters

Find LI = FIND(",",Old Value,1)

New Value = IF FIND LI = 0 THEN Old Value ELSE Left(Old Value,Find LI -1)

This should give you the results

prabhu · April 2020

Create a new Line item(number format) and write a formula FIND(",", old)

Write the formula for new value = IF New Line item = 0 THEN old value ELSE LEFT(old value, New Line item - 1)

Hope it helps,

Akhtar.shahbaz · April 2020

You can try this

Hope this helps!

Thanks

Akhtar

johndorma · April 2020

SUBSTITUTE() is also an option and that will allow for replacing multiple instances of the same character without something super complex.

Sravan_Kumar · April 2020

As a community learner, I feel your responses to help new learners deserve much more than applause.

I am really credited to the community, it is making me learn Anaplan having so many helping hands.

Sravan_Kumar · April 2020

Wow! Amazing @johndorma.

Sravan_Kumar · April 2020

But this doesn't work if something is present after comma.

Say,

5.0 ----> 50

but using the formuls,

5.0 -----> 6

Best Answers