Page 1 of 1

dropping the decimal values in a calculated field

Posted: Fri May 22, 2015 11:18 pm
by mikemc
I am dealing with large dollar values andI would like to just drop the decimal value in calculated fields 4.556 becomes 4

Re: dropping the decimal values in a calculated field

Posted: Sat May 23, 2015 12:16 am
by sefrojones

Code: Select all

on mouseup
   put 4.556 into MyDollarValue
   set the itemdelimiter to "."
   put item 1 of MyDollarValue
end mouseup
--Sefro

Re: dropping the decimal values in a calculated field

Posted: Sat May 23, 2015 12:24 am
by mwieder
put trunc(4.556)

Re: dropping the decimal values in a calculated field

Posted: Sat May 23, 2015 12:49 am
by mikemc
Thanks its working :D