Find formula

Hi Friends,

Do we have any special formulas for the below calculation.

Tags

Modeling

Calculation Functions

Accepted 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

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,

Hi @Sravan_Kumar

You can try this

Hope this helps!

Thanks

Akhtar

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.1256721239.1586888949-1317535828.1586888949 Screen Shot 2020-04-14 at 2.34.55 PM.png

All comments

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

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,

Hi @Sravan_Kumar

You can try this

Hope this helps!

Thanks

Akhtar

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.

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.1256721239.1586888949-1317535828.1586888949 Screen Shot 2020-04-14 at 2.34.55 PM.png

Wow! Amazing @johndorma.

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

Say,

5.0 ----> 50

but using the formuls,

5.0 -----> 6

Quick Links

Can you help?

Unanswered questions

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…