Skip to Content
0
Former Member
Apr 16, 2012 at 10:36 AM

Calculated Measure - Decimal precision

893 Views

Hi,

I am trying to create a calculated measure result = (occupied seats / maximum seats)*100, (These 2 columns are of data type integer and result is of the data type decimal 5,2). The result is just showing "0.0" for all the values, instead of the actual precision (values after decimals) wherever valid is just says "1.0" but most of the cases its "0.0" instead of the actual values.

The calculation looks simple, but I am not able to derive the actual value

Can someone help in this calculation.

Thanks!!