Hello all,
I have an issue with an overall result row of the formula. I have a formula (Z), where I have to divide X key figure by Y key figure. Y kf is just a regular kf. X kf is another formula. X kf formula = A - B. sometimes A is greater than B and sometimes A is less than B. So, X kf formula is written as ABS(A - B). I only want the actual difference, I don't want negative values. with absolute value my Grand total is greater than without absolute value. When calculating Z, in the overall result I only get the value as if absolute value was not applied to A - B.
Here is an example:
a ////////// b ///// x = a - b //////ABS(x) /// /// y /// z = ABS(x) / y
3,632 ////// 4,148 ////// 516 ////// 1,686///// 4,148 ///// 12.4335868
1,750////// 1,165 ////// 585////// 585///// 1,165 ///// 50.2054381
1,750 ////// 1,165 ////// 585 ////// 585///// 1,165 ///// 50.2054381
1,304 ////// 2,383 ////// -1,079 ////// 1,079//// 2,383 ///// 45.2896898
1,304 ////// 2,383 ////// -1,079 ///// 1,079 ////// 2,383 //// 45.2896898
578 ////// 599 ////// -21///// 21////// 599 //////////// 3.5340260
578 ////// 599 ////// -21///// 21 ///// 599 //////////// 3.5340260
If you look at the first row of values. Z is not correct. the formula should be: 1686/4148 = 40.xxxxxxx
It seems to still be using the value 516 from X in the grand total. My requirement is to use the 1686 value from the grand total in the Z formula. As you can see, everything is ok except the grand total. I think it's applying the ABS for individual records. Can anyone please give me some suggestions on what to do? Why can I make the grand result of X show as 1686 but can't apply that value in the Z formula? I appologize for the way the example looks. I couldn't get the spacing right. Thank you all in advance.
Leo.