Query & Analysis Excel Web Add-in formulas

Q&A Cloud formulas available to use in Q&A Excel Web Add-in.

Note: The number of Q&A Cloud formulas in one recalculation is limited to 300.
Note: The number of displayed rows per calculation for Detail Report or Summary Report is limited to 1000.

Reference Link formula

The Reference Link formula returns the value of a single record. However, a single query can output multiple data items for that record.

Infor.QNA_RL("String”,<CellReference1, CellReference2…>)
The Infor.QNA_RL formula syntax has these arguments:
  • String – this argument is required. It contains version, product code, filter values and output items.
  • CellReference – this argument is optional. The CellReference is required, when a filter value in String is referenced to cell value.

Summary Link formula

The Summary Link formula returns the balance of a filtered range. One formula can output multiple data items for the selected range of records.

Infor.QNA_SL("String”,<CellReference1, CellReference2…>)
The Infor.QNA_SL formula syntax has these arguments:
  • String – this argument is required. It contains version, product code, filter values and output items.
  • CellReference – this argument is optional. The CellReference is required, when a filter value in String is referenced to cell value.

Summary Report formula

The Summary Report formula returns summarized listing from your database into a worksheet. There is one row that contains all the Data Output Items for each summary level.

Infor.QNA_SR("String”,<CellReference1, CellReference2…>)
The Infor.QNA_SR formula syntax has these arguments:
  • String – this argument is required. It contains version, product code, filter values and output items.
  • CellReference – this argument is optional. The CellReference is required, when a filter value in String is referenced to cell value.

Detail Report formula

The Detail Report formula returns detailed listing of reference information and transactions from your database. There is one row for each record in your database.

Infor.QNA_DR("String”,<CellReference1, CellReference2…>)
The Infor.QNA_DR formula syntax has these arguments:
  • String – this argument is required. It contains version, product code, filter values and output items.
  • CellReference – this argument is optional. The CellReference is required, when a filter value in String is referenced to cell value.

Aggregated value formula

The Aggregated value in Summary Report results and can be drilled down. 

Infor.QAA_AGG("String”,)
The Infor.QNA_AGG formula syntax has these arguments:
  • String – this argument is required. It contains version, product code, filter values and output items.