Forum Discussion

GB_DirectorOfOn's avatar
GB_DirectorOfOn
Qrew Trainee
12 years ago

Keeping (or adding) decimal places when converting number to text...

I'm working with multiple currencies and trying to combine them into a single field (I realize this won't allow me to have a total due to the fact they're converting to text in order to maintain curr...
Formulas and functions
Tables and fields
UNISBOT's avatar
UNISBOT
Qrew Member
8 years ago
This hasn't been updated in a while, but I was able to create a simple formula solution for this issue. 

Part(ToText([Discount Total]),1,".")&"."&Left(Part(ToText([Discount Total]),-1,"."), 2)