Register

Community Boss

## Find formula

Hi Friends,

Do we have any special formulas for the below calculation.

7 REPLIES 7
Moderator

## Re: Find formula

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

Community Boss

## Re: Find formula

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,

Sorna Raja Prabhu
Community Boss

You can try this

Hope this helps!

Thanks

Akhtar

Community Boss

## Re: Find formula

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.

Certified Master Anaplanner

## Re: Find formula

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

Community Boss

## Re: Find formula

Wow! Amazing @johndorma.

Community Boss

## Re: Find formula

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

Say,

5.0 ----> 50

but using the formuls,

5.0 -----> 6