Skip to Content
1
Former Member
Aug 01, 2007 at 12:19 AM

Calculating decimal rounded KF's in query

18 Views

Hi,

I have a query where i rounded up the KF's to decimal 0.0 and the scaling to 1million. That works fine. So far So good.

But in the structure I have a formula too, where I'm adding up a couple of columns (KF's). Here is the problem I face, the formula doesnt take the rounded decimal value of KF into consideration, rather sums up with the 8 decimals places (which I think is expected). But I want to make the system add up only the rounded KF's. So obviously my numbers arent tying up.

Is there a way i can achieve this? I ran out of all tricks up my sleeve.

Ex:

kf - act value - rounded value

A - 551.92481620 - 551.9

B - 53.02527867 - 53.0

Expected value - 551.9+53 = 604.9

actual value - 605 (as that doesnt take the rounded decimals into consideration)

Any pointers or suggestions are appreciated.

Thanks,

Voodi