Q&A 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.
  • 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 a 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 a 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 references a cell value.

Aggregated value formula

The Aggregated value formula returns an aggregated value from Summary Report results that can be drilled down.

Infor.QNA_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.