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)
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!
Thanks, simple and effective solution!
You're welcome! Please accept the answer as well.