function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Brian NolauBrian Nolau 

When I make a report based off of Reports, why can't I use all the columns from the individual reports in the new report?

As the title says, I want to do math with Report 1 and Report 2. Why can't I reference both report columns in a new Report? The Report columns for Report is so dumb it has Name, Description, Created By, Folder, Last Modified By, and Last Run when instead I should be able to select which report I want to pull fields from and which fields I want.
SwethaSwetha (Salesforce Developers) 
HI Brain,
Have you tried using joined reports to see if it pulls the columns and fields you want? A joined report can contain data from multiple standard or custom report types. You can turn any existing report into a joined report using the report builder.

See https://help.salesforce.com/articleView?id=reports_working_with_joined.htm&type=5
https://trailhead.salesforce.com/content/learn/modules/reports_dashboards/reports_dashboards_report_types#joined-reports

I am happy to answer any follow up queries if any. If this helps, please mark the answer as best.Thank you