Absolute value of year value

I would like to sum an absolute value of a monthly line item. Might for example have values -2 i january, -3 i february and +5 in March. Would like a line that calculates the absolute yearvalue of this as 2+3+5=10 (not -2-3+5 = 0)

Accepted answers

umangsinghal

Create another line item for absolute value and put formula there ABS(Value). Reference this new line item to your Yearvalue formula.

Hope this helps!

All comments

umangsinghal

Create another line item for absolute value and put formula there ABS(Value). Reference this new line item to your Yearvalue formula.

Hope this helps!

samdal

Thanks, simple and effective solution!

umangsinghal

You're welcome! Please accept the answer as well.

Quick Links

Can you help?

Unanswered questions

403 error trying to access Support Portal
Hi - can't access support portal having already registered. Receive the following error message - is this an issue with Anaplan or our internal IT?
Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…