Esko Logo Back to Esko Support
Choose your language for a machine translation:



When creating calculated expressions to be used on Reports or in database Userfields, what are the different formatting options available?


Typically when creating a calculated expression, the formatting options are available via the calculated expression Properties page:

These options in essence hide the underlying Interact scripting function being used.

In certain cases, it may be necessary to manually create this expression. In such cases, the function being used is called NUMTEXT and it has a number of parameters:

NUMTEXT(val, iformat, ndecimals, btrailzero)


val - number being formatted (e.g. CAL)

iformat - formatting option

= 0, Default format for length values, depends on units

= 1, Decimals

= 2, Big fractions

= 3, Small fractions

= 4, Sixteenths

ndecimals - number of decimal places

If iformat = 0, number of decimal places is ignored

If iformat >= 2, number of decimal places is used when the value does not round to an exact number of 1/64ths or 1/16ths

btrailzero - option to show trailing zeros

= 1, Include trailing zeros.

= 0, No trailing zeros.

For example, the expression NUMTEXT(L,1,2,1) will produce the result 3.50 when L has a value of 3.5.

Article information
Applies to

 ArtiosCAD all versions

Created 12-Mar-14
Last revised 
Author MRAN
CW Number