Rounding a number in a field
Posted: Fri Jun 08, 2012 5:37 am
Hi everyone,
I'm having trouble with using the round or trunc functions. I have a number in a field called numberfield and I can't seem to round it or truncate it and was wondering if anyone has any advice.
I tried using:
round(field "numberfield") and round field "numberfield"
and I did the same with trunc to no avail.
Any help would be greatly appreciated! Thank you!
I'm having trouble with using the round or trunc functions. I have a number in a field called numberfield and I can't seem to round it or truncate it and was wondering if anyone has any advice.
I tried using:
round(field "numberfield") and round field "numberfield"
and I did the same with trunc to no avail.
Any help would be greatly appreciated! Thank you!