Skip to Content
0
Former Member
Aug 10, 2007 at 05:30 AM

Sub total error in BEX

12 Views

Hi Guys,

I have 3 KFs in my report- C1, C2, C3.

Values in the all the KF are as follows -

c1 - 13.21 , 15.53

c2 - 35.21, 46.24

c3 - 64.23, 45.23

I want to calcuate the average sub total of all the records under KFs, based on the

following Condition ...

the decimal part of the value should not be more than 59 after the total. if its more than 59 it should add up to the before value.

say in the c1 case : 13.21 + 15.53 = 28.74. but by the above condition, the correct value is 28.24.

can i write the above condtion in my BEx report.

plz help.

thanks - pra