Fantastic - thank you :-)
When I follow the instructions.. and paste it into my calculation field - FM Pro 11 (on Mac OSX) I get an error
"An operator (e.g. +, -, *,...) is expected here" - just between "Order_Purchasing_Price" which is my substitute for 'NumberField' and 10^12...
Choose(Int(Mod(Order_purchasing_price,10^12) / 10^11),
I found out that "," need to be replaced by ";" - and that ".01" doesn't comply to Danish MacOSX systemt, so changed that one to ",01" - and the formula works fine.. Thank you a lot - saved me at least a couple of hours... Great!
I think you lost a ). There should be a equal number.
Sent from my mobile device... Please excuse typos.