Truncating the decimal Number

[George Spofford]

If you need truncated for display purposes only, then define the
calculated measure to subtract 0.5 and use #,# formatting.

If you really need truncated numbers, try using the VBA!Int() function

VBA!Int ( <expression> )

HTH

Awtar wrote:

> Hi
>
> In one of the my Cubes i am using Calculated Measures.
> In which truncate number function is required .
> Like 2.56 to 2 in MDX function.
> If i specify the number Format #,# it convert 2.56 to 3.
> Pls tell me how can i do this in Calculated Measures.
>
> Thanks In advance
> Awtar

--
George Spofford
Microsoft MVP
Chief Architect / OLAP Solution Provider
DSS Lab
http://www.dsslab.com
geo...@dsslab.com
ISVs & IT organizations: Find out how DSS Lab can speed your
development!