Hi, struggling with a formula for converting a currency field into minor units.
Example: Formula field adding two currency values (£50.45 & £40.20) gives value £90.65. I need a formula that returns this value as 9065 - but I cannot work it out.
In Excel it would be a simply TRUNC, but Airtable doesn't seem to have this feature. I'm amazed this question hasn't been asked before, but cannot find it anywhere!
Ellis...
Does this accomplish what you are trying to do?
If so, the formula is just
Ellis...
Does this accomplish what you are trying to do?
If so, the formula is just
Thanks Ron, it doesn't quite (my fault, bad example) but I now realise why nobody has asked this question before as the answer is blindingly obvious and I feel like an idiot for asking it! I was looking for a way more complicated solution than required... Thanks again!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.