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