I want to create a new column in my custom report.
Scenario: I have a object say Ticket and it has two field created_date and closed_date. Now I want to create a column called Age(number) of that ticket. which is calculated by closed_date - created_date.
I achieved this by creating a new formula field in Ticket Object.
But can I do this without creating a custom field in object. Is there any way to create a temporary field just for report? In report builder there was one option to add formula field but to create a formula with my date fields is not possible.