Forum Discussion

rahulrahul1's avatar
rahulrahul1
Qrew Trainee
9 years ago

Is it possible to convert the numeric field in words currency?

Example.. I have one Numeric field salary [23000]. Now i want to convert the value of this numeric field into text field as "twenty three thousand dollars ". It would be great help if you can guide ...
Tables and fields
rahulrahul1's avatar
rahulrahul1
Qrew Trainee
9 years ago
Thanks Coach, I had replaced it with Variable but i found one issue with this formula.
Example - Number = 11600 then formula is giving value "Ten One Thousand, Six hundread dollars" ideally it should say "Eleven thousand and Six hundread dollars" ? i am trying to fix it but would be great if you can tell me which variable is causing this issue? thanks