AX report builder formula issue

Hi!

Let me see if i can explain this… I’ve built a report using report builder in AX 4.0. In the report i have a column that includes both negative and positive values.

I want to divide this out into two additional columns. One column that only contains the negative numbers of the first column, and a second one only containing the positive numbers.

Does anybody have an idea to a formula that can do this for me?

Help will be most appreciated:)

Henrik (DK)