KB154665994: ArtiosCAD - What are the different formatting options when creating calculated expressions

Question

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

Answer

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)

where:

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.