Report is giving error while importing when the report is having sub query and calculated fields
I am having the issue when importing the report which is having the subquery union. It gives me the error while importing the report saying that "Calculated field is invalid". The report has not imported successfully.
The issue occurs only when subquery union is having calculated fields. Attached is the Report XML which is build on SKITEAM Datasource. Attached are the error screenshots for your reference.
Below are the steps to replicate the issue.
1. Create the report and add the subquery "union" to the report.
2. Create calculated fields
Calc1: INVOICEDAMOUNT + 100
Calc2: INVOICEDAMOUNT + 200
Calc Invoiced Amount: Calc1 + Calc2
3. Use this calculated field "Calc Invoiced Amount" in Report fields
4. Save the Report
5. Export the Report
6. Import the Report and now you will get the error "Calculated field Calc Invoiced Amount is invalid"
7. You can't run the report
7. If you open the formula for "Calc Invoiced Amount". It will be like this null+null.
Below is the system information. The issue exists in 7.1 as well
Application Version:7.3Build:20170523Java Version:1.7.0_80Operating System:Linux 2.6.32-642.3.1.el6.x86_64 (amd64)