Find formula

[Sravan_Kumar]

Hi Friends,

Do we have any special formulas for the below calculation.

[Misbah · Accepted solution]

@Sravan_Kumar

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 · Accepted solution]

Hi@Sravan_Kumar-

Create a new Line item(number format) and write a formulaFIND(",", 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 · Accepted solution]

Hi@Sravan_Kumar

You can try this

Hope this helps!

Thanks

Akhtar

[Sravan_Kumar]

Thanks@Akhtar.shahbaz,@prabhu,@Misbah.

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.

[johndorma · Accepted solution]

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

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUBSTITUTE.htm?_ga=2.210251925.1...

[Sravan_Kumar]

Wow! Amazing@johndorma.

[Sravan_Kumar]

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

Say,

5.0 ----> 50

but using the formuls,

5.0 -----> 6