Round the results w/o decimal places

N

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
 
N

Newbie

Reid,
Thanks a lot!

Reid McTaggart said:
ROUND(Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Work]),0)


--
Reid McTaggart
EPM Architect
Microsoft


Newbie said:
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
Click to expand...
Click to expand...
 
G

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.




Newbie said:
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


Newbie said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top