Calculating decimal rounded KF's in query

[Former Member]

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

[Former Member]

OK.

Another check; what is the setting for the base key figure that is used in the calk key fig? I mean how many decimals places you have defined for the key figure info object in RSA1.

Also, in the cube, do tou see the data for the key figure with decimals? This is another check.

In the worse case scenario, we can always code a routine and make the decimals to work the way we want.

Ravi Thothadri

[Former Member]

All the numbers are the way I want them to be, both in cube and IO. I dont want to derive this decimal notation on the cube level as I have different other queries based out of this cube which require the regular decimal notation.

[Former Member]

Thanks for all the help. I figured it out.

Message was edited by:

voodi

[former_member712242]

I am also facing same problem.Could you please let me know how u resolve this issue.

[Former Member]

Do you round off the cal key fig / formula? at all.

If so remove the round off property and try again.

Ravi Thothadri

[Former Member]

Thanks for the reply.

I already tried that - doesnt work.