Editar

Compartir a través de

ReverseSign Property

  • Artículo

Version: Available or changed with runtime version 1.0.

Changes negative values into positive values and positive values into negative values in a column of a resulting query data set.

Applies to

  • Query Column

Note

The ReverseSign property applies only to columns that have a numeric data type. If you set the ReverseSign property on a column that does not have a numeric data type, you will get an error.

Property Value

True to reverse the sign of column values; otherwise, false. The default is false.

Syntax

ReverseSign = true;

Remarks

Field values in a database table can be negative numbers, as well as positive. For example, credits are typically stored as negative values to deduct them from the overall balance due. However, for displaying purposes, such as in spreadsheets and charts, you might want these quantities to appear as a positive numbers.

Properties
AL Data Types