Absolute value of year value

samdal
samdal
in Modeling

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)

Best Answer

  • umangsinghal
    umangsinghal
    Answer ✓

    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!

    Regards,

Answers

Categories