Page 1 of 1
Absolute value only summing last value in group
Posted: Thu Oct 23, 2014 2:21 pm
by laducd
How can i get the absolute vale for an entire group. Currently it is only pulling the last value in the group.
{Abs(Fx_Position_Report.Notional_Amount)}
Re: Absolute value only summing last value in group
Posted: Fri Oct 24, 2014 7:57 am
by HighAley
Hello.
The Abs() is not an aggregate function.
Could you specify what do you need to get?
With small sample, please.
Thank you.
Re: Absolute value only summing last value in group
Posted: Tue Oct 28, 2014 7:08 pm
by laducd
Figured this out
Re: Absolute value only summing last value in group
Posted: Wed Oct 29, 2014 7:43 am
by HighAley
Hello.
We are always glad to help you.
Let us know if you need any additional help.
Thank you.