Skip to Content
0
Former Member
Jan 11, 2007 at 05:24 PM

Decimals places to 4

112 Views

In my layout I am using 0AMOUNT and US$4 with 4 decimals. When I key a number into the layout, regardless of what it is, it is correct in the layout. However, when I look in the cube or query, if the value I put in the layout is equal to or less than .0040, it appears as 0. If I put in .0041 or higher, I see that value in the layout and also in the cube and query.

Thanks, Keith J