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.
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.