Find formula
Hi Friends,
Do we have any special formulas for the below calculation.
Best Answers
-
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
1 -
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,
1 -
1
-
SUBSTITUTE() is also an option and that will allow for replacing multiple instances of the same character without something super complex.
3
Answers
-
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.
2 -
Wow! Amazing @johndorma.
1 -
But this doesn't work if something is present after comma.
Say,
5.0 ----> 50
but using the formuls,
5.0 -----> 6
0