In the calculated measure formula when something is being divided by 0.XX (like 0.35..fractions) its producing those wrong figures where decimal is at a wrong place. But if we divide the numerator and denominator by 100, we get the correct figures.
[something].[Something] *100 / 0.XX *100 = good
[something].[Something] / 0.XX = wrong
Why is that? and what can be done to do it right. Thanks.
Are you using AS 2000 or AS 2005, and can you reproduce this problem with one of the standard cubes (like Foodmart or Adventure Works)?
No comments:
Post a Comment