Error occurs when using Subtract, Addition, or Divide SQL query
SummaryError occurs when using Subtract, Addition, or Divide as one of the select columns.
Error MessagesError - (Code-Pega-List)** An error occured on generating the query for the report definition - null
Steps to Reproduce
- Create two subreports.
- Use Summarize (sum) in the both the subreports.
- Add the column of both the sub reports in main report.
- Use the Divide function for the column of subreport1 to column of sub report 2.
- Run the Main report definition.
Root CauseRuntime value was not set for all function aliases that have a parameter with Join type as None (do not join rows).
Published November 21, 2018 — Updated January 12, 2019