Show different calculations in data elements in a Query object.
|Difference ||Displays each number on the series as the difference from a base value|
|No calculation ||Displays each number on the series as it is returned from the database (this is the default value)|
|Rolling average ||Displays each number on the series as the average of a subset of the original values|
|Running total ||Displays each number on the series as the summation of the previous values|
Generators: .NET, .NET Framework, Java
Level: Query element
You may use the Show values as property to quickly show values in different ways. This property is used along with another set of properties to specify a set of calculation options (see below).
You may use this property to show different calculations in a query element. But since you can add the same element to a Query more than once, you may also use this feature to show the actual value and other calculations, such as a running total calculation, side by side.
This property applies only at design-time.
To apply the corresponding changes when the property value is configured, Run the main object.
This property is available since GeneXus 17 Upgrade 9.
Average type property
Number of terms property
Show as percentage property
Difference from property