Monday, March 19, 2012

How to round the measures (fields in fact table) to a nearest integer.

How to round the measures (fields in fact table) to a nearest integer.

These measures were displaying the decimal places and I want to get rid of decimals by rounding.

How to implement rounding for these measures.

Thanks In Advance

Anil Pasupula

Just use the format string for the measure to format it. e.g. "#,0". It will round it correctly.|||Thanks for your solution.

No comments:

Post a Comment