Skip to Content
0
Former Member
Apr 20, 2010 at 11:49 AM

KF rounding issue

26 Views

Hi,

I have a query based on a cube which deals with sales data. In this query a lot of calculations are done based on a small number of base key figures.

As a simple example, turnover (500) devided by quantity (1000) should lead to a price of 0.5.

A week ago I had to add some more calculations and since then all values get rounded. It looks as if the result is no longer a decimal but an integer instead.

The above example now gives me 1 instead of 0.5

Nothing else was changed, just adding some further calculations. Also the base data has not changed. It's a development system where the last data import was in august, 2009 so the data in the cube is correct.

Also if I adjust the formula to: turnover/quantity*1000 the result is 500 (according to the example of the beginning). So for some reason the calculation is done with correct values but the presentation has changed.

I have no clue how to solve this...

Please advice.