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:
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
@SarahE
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
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
