How can I format numbers in a calculated field?

  • Profile Image
    BDJJAKARTA
    Asked on December 02, 2015 at 07:17 AM

    For instance instead of 11100000 I would like to format it this way 11.100.000 (eleven-million-one-hundred-thousand)

  • Profile Image
    victor
    Answered on December 02, 2015 at 09:27 AM

    As the calculation widget only takes numeral values from the operands (when doing arithmetic calculations not string concatenation).

    Therefore, the input mask CANNOT be retained. Sorry about that.

    As a work around you could use another text box with a mask and create a condition to update that value.

    Result, input mask is used in the output:

    Please let us know if this helps.