Thanks. I did read that and was able to get the numbers to round down, or up. Is there a way to do both?
I don't follow what you mean. Do you want two calculations producing two different results, one that rounds up and one that rounds down?
My calculated field returns a dollar amount. I want to round it to the nearest quarter dollar. Not necessarily up or down, just the closest.
As an example, if the number returned was $5.07, I would like the calculation to round down to $5.00. If it were $5.17, then it would round up to $5.25.
Something like this?
value = 5.17 ;
quartered = value * 4 ;
rounded = round ( quartered ; 0 ) ;
result = rounded / 4