How can I format numbers in a calculated field?

  • BDJJAKARTA
    Asked on December 2, 2015 at 7:17 AM

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

  • victor
    Replied on December 2, 2015 at 9: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.

    How can I format numbers in a calculated field? Image 1 Screenshot 30

    Result, input mask is used in the output:

    How can I format numbers in a calculated field? Image 2 Screenshot 41

    Please let us know if this helps.