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.
ArtiosCAD all versions
Note: This is an anonymous survey. If you need help from Esko Support, register a Support Case here.