Round the results w/o decimal places

[Newbie]

Hello,
The following formula in the OLAP Cube give a result with 6 decimal places.
How can I get rid of all these decimal places.
Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Work])

Thanks

 

[Reid McTaggart]

ROUND(Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Work]),0)

 

[Newbie]

Reid,
Thanks a lot!

ROUND(Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Work]),0)


--
Reid McTaggart
EPM Architect
Microsoft

Hello,
The following formula in the OLAP Cube give a result with 6 decimal places.
How can I get rid of all these decimal places.
Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Work])

Thanks

 

[Gary L. Chefetz [MVP]]

Besides applying rounding, you can also apply formatting. In this case you
might want to format the result so that it includes the "h" in the display
to match the other work fields in the analyzer.

Reid,
Thanks a lot!

"Reid McTaggart" <[email protected].(donotspam)> a écrit dans le
message
de news:[email protected]...

ROUND(Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Work]),0)


--
Reid McTaggart
EPM Architect
Microsoft

Hello,
The following formula in the OLAP Cube give a result with 6 decimal places.
How can I get rid of all these decimal places.
Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Work])

Thanks