Positive and Negative values

[#1]

See attached, How do i fabs the negative data and negate the positive data?

[swuehl]

Not sure I understand, are you looking for

=Sum(-Data)

?

[sunny_talwar]

May be multiply by -1

Sum(Data) * -1

[#4]

No, See the table. I wanna change negative values to positive and change positive to negative

[#5]

No Sunny, I wanna change positive values to negative why negative to positive

[sunny_talwar]

That's what this is doing. When the sum is positive, it will make it negative and when it is negative, it will make is positive

[martinpohl]

I don't what the problem is with sum(-Data)

It will change positive values to negative and negatives to positive

[#8]

See attached:

I have a field called Data. It has both Negative and Positive values. I want to make the positive values negative why the Negative values positive. Clear?

[swuehl]

So it's about grouping the data, then reversing the sign?

=Sum( Aggr(-Sum(Data), no))

edit: No, it's not clear what you are asking for without knowing your requested result (AKA what you expect to see).

[#10]

I want to do this at the backend not on the chart