When adding query elements to a query definition, several options are available to  be assigned.

Arithmetic expressions

Any valid arithmetic expression such as:

• CustomerAge + CusIdentifierId – 1245
• InvoiceSubtotal * 2

Aggregate expressions

Any valid aggregatte expression such as:

• Sum(CusId + CusId)
• Sum(InvoiceTaxes+InvoiceNonTaxes)
• Sum(CusId) + Sum(CusId)
• Sum(InvoiceTotal)/Count(InvoiceId)

Filtering expressions

A valid filtering expression:

• Sum(InvoiceTotal) where YearId = 2008
• Sum(InvoiceTotal) where YearId < 2008 / Sum(InvTot) where YearId > 2007

Functions

The following list of available functions can be used:

• AddMth
• AddYr
• EoM
• YMDHMStoT
• YMDtoD
• Lower
• LTrim
• PadL
• PadR
• RTrim
• Str
• StrReplace
• Substr
• Trim
• Upper
• Age
• Dow
• Hour
• Int
• Len
• Minute
• Month
• Second
• StrSearch
• StrSearchRev
• Year
• Round
• Trunc
• Val

Examples

• Month(InvDate)
• Trim(Str(Year(InvDate)))
• Upper(CustomerName)