Find formula

Highlighted
Super Contributor

Find formula

Hi Friends,

Do we have any special formulas for the below calculation.

 

Sravan_Kumar_0-1586872031018.png

 

7 REPLIES 7
Highlighted
Master Anaplanner/Community Boss

Re: Find formula

@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

Highlighted
Super Contributor

Re: Find formula

Hi @Sravan_Kumar  - 

 

 

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
Highlighted
Super Contributor

Re: Find formula

Hi @Sravan_Kumar 

You can try this

Screenshot_291.png

 

Screenshot_292.png

 

Hope this helps!

Thanks

Akhtar

Highlighted
Super Contributor

Re: Find formula

Thanks @Akhtar.shahbaz , @Sorna Raja 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.

Highlighted
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. 

 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUBSTITUTE.htm?_ga=2.210251925.1...Screen Shot 2020-04-14 at 2.34.55 PM.png

Highlighted
Super Contributor

Re: Find formula

Wow! Amazing @johndorma.

Highlighted
Super Contributor

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