The value or string parameter or relation attribute @NOCOMMAFORMAT is used to supresses grouping comma's ("1,000,000") if the option is selected in the Quaestor Options settings.

Syntax

Place @NOCOMMAFORMAT in the data slot of the parameter or relation

Remarks

This attribute is required when input files are created for external process that are not able to process comma's in values (most command-line programs). Can also be used to uppress comma formatted values in (Word) reports by providing the attribute to the relation using the relevant TEMPLATE$() or WINWORD$() functions.

Member of functional group: Template

Member of knowledge base type: Classic and general type, Scenario type and Taxonomy type

Examples

If the attribute is, for example, included in the data slot of a relation using the TEMPLATE() function. And in this function the parameter "ID" is used with a value of 1275, the value of ID is included as "1275" and not as "1,275" (when the option "Show commas in numbers 12,500.00"" in the Options>Appearance tab was checked). If there are other parameters in the template for which the comma format is to be used, one can include the @NOCOMMAFORMAT in the data slot of the ID parameter to avoid only using the comma format for ID.

 

 

 

Quick links: Function overview | Attribute overview | Constants overview | Dimensions overview