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

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…