Amount_export_c = amount * 100
Tom Fitch wrote:
Int ( Amount * 100 )
This does not work. It just adds 2 zero's to whatever amount I have.
so 3.12 turns into 31200 ( so I could strip right(2)) but
3.1 gives me 3100 which stripping does not work....remember that filemaker stores 3.10 as 3.1 and 3.00 as 3 and 3.23 as 3.23
mcarey wrote:This does not work. It just adds 2 zero's to whatever amount I have.
Then something is off with your number (?) field; 3.1 * 100 should return 310, no matter whether the number is internally stored as 3.1 or 3.10.
If 3.12 returns 31200, it suggests that the period is not recognized as decimal character, so the number used is actually 312.
btw, Tom's suggestion is better anyway (when applied to numbers, that is), since it works with any number of decimal places to return the result you described.
Int( Amount * 100 )
How to export number field to text with 2 decimal placesNice. Reminds me of the old days...
Works if the field is text...
And Int is good for getting the version numbers. int(get(applicationversion)) = 13 which I am having to use more and more...
Mark Tom Fitch as the correct answer...