Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Wrong Result Row % Calculation

Note: Use ! as column seperator.

K1 ! K2 ! D=K1-K2! D%A K1 ! D1=ABS(K1-K2)! D1%A K1

-


1,020 ! 750 ! 270 ! 26 % 270 ! 26 %

340 !1900 ! -1,560! -459% 1,560 ! 459 %

34,201! 34,201! 100 % 34,201 ! 100 %

5,551 ! 5,551 ! 100 % 5,551 ! 100 %

1,160 ! 120 ! 1,040 ! 90 % 1,040 ! 90 %

-


42,272! 2,770 ! 39,502! 93 % ! 42,622 ! 93%

ERROR column is D1%A K1.

Result row 93% is supposed to be 101%. Appears like its using 39502 of column D=K1-K2 instead of 42622 of column D1=ABS(K1-K2) and doing the calculation.

Tried all the formula collision options. Fun part is there is one more formula field in the report with same formula as (k1-k2)%A k1 or D %A k1and i get right result here. But it doesnt give me the right result for other formula field with same calculation except that it is ABS(K1-K2)%A K1 or D1 %A K1.

Thanks

Kiran.

Former Member
Not what you were looking for? View more on this topic or Ask a question