Answered

Format Numeric field that you are currently typing in

Is it possible to format a numeric field that is currently being typed in. 


I know the format-num function works but that seems to only work if there is a field i can reference. Essentially is there anything to use a function similar to {{this}} to format the numeric field?

  • Hello. Numeric fields must be numbers only. If you want to format a number, such as to currency, use another field, such as a hidden field or a text field, that uses something like this:

    CONCAT('$',FORMAT-NUM({{NumericField}}, '#,###.00', en-US))


    Does this help you? 

Login or Signup to post a comment