ABS formula

Hi,

anyone who can help on formula "ABS"?

I need to get the absolute value of the line item, but Anaplan seems to round off the item.

Any notes on this? Thank you.

Below is the screenshot for sample:

Accepted answers

Hi Sarah,

The issue is with the VALUE formula and not with the ABS formula

This occurs in Anaplan when the value formula is used on a string greater than 16 characters

Screenshots below taking example of Row 8 in your screenshot

16 chars screenshot

17 chars screenshot

I don't think there is any way to avoid this behavior..

Can you please elaborate on why this formula is required and maybe we can think of another way of achieving it

Regards,

Anirudh

Silly question

Could you try bringing in the contract number as a number? and then convert to text to join with the company code

Also, why do you need the ABS, that will only happen if the Company code is negative?

And do you need the Company code and contract number as a number rather than a text field?

Finally, it would be better to provide the join in the source file if possible - that prevents all of the above!

David

ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…