Formatting for Currency

[jb]

What's the best formatting to use when you're inputting dollar amounts? I have tried Int 64, Double and Fixed Decimal but keep getting warnings that some of the data is being cut off/ lost because the decimals go out too far. Thanks!

[MarqueeCrew]

Integers wouldn't be my first choice.  Double is a safe bet.  If your decimals are going out too far, you probably have mathematic operations that are creating the precision issue.  I don't like having to ignore warnings, but if you're getting them and you've reviewed your workflow then ignorance is bliss.

"you always double down on 11"

Mark

[JordanB · Accepted solution]

Hi jb,

You can adjust the fixed decimal length, I beleive the default in 19.6 but you can change the value after the period to a larger value. 

However, if you are going to add the $ sign then it will change it to a V_String, so maybe having the dollar amount as V_String to start off with will be best, as the string length is usually 256 so therefore it will not cut off any of the decimal points.

Best,

Jordan Barker

Client Service Support Representative