This content has been marked as final.
Show 3 replies

1. Re: ABS Function  Absolute is not calculating the absolute value.
Michel Caissie Jan 13, 2014 12:00 PM (in response to Karthik Ravikumar)Your cost difference calculation doesn't really make sense , since a row is either A or B you cant calculate the difference using a row calculated field. You need to aggregate before calculating the difference.
You should replace
zn([CostA])zn([CostB])
with
SUM( [CostA] )  SUM( [CostB] )
After that ABS([costDiff]) will work as expected
Michel

2. Re: ABS Function  Absolute is not calculating the absolute value.
Karthik Ravikumar Jan 13, 2014 12:11 PM (in response to Michel Caissie)1 of 1 people found this helpfulMichel
That was very helpful. Really appreciate your speedy response!!!!!!
Regards
Karthik

3. Re: ABS Function  Absolute is not calculating the absolute value.
Peter Gilks Jan 13, 2014 12:11 PM (in response to Karthik Ravikumar)1 of 1 people found this helpfulHi Karthik,
When you look at the underlying data you can see that ABS is working, but it works at the row level.