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