+ Start a Discussion
hy.lim1.3897974166558203E12hy.lim1.3897974166558203E12 

Create custom column in report based on row calculation in Matrix Report

Hi I have a custom report (Activities with Case) created like this ->

User-added image

Now I would like to add an additional column and value would be 'Email - Received' - 'Email - Sent'. Possible to do that? 
Sonam_SFDCSonam_SFDC
If I understand this correctly..you wish to segregate the emails recieved and sent from  a case and show them in the two columns.

Emails sent/recieved are stored in the email related list and the read/sent is stored under a SINGLE field which is "Status" you can run the report using Case with Email report type and pull up the report in the following format:

Case Owner/ Account Name /Subject/Date/Time /Opened Age (Hours) /Open/ Closed/ Email/ Subject Email /Status
hy.lim1.3897974166558203E12hy.lim1.3897974166558203E12
Hi Sonam, thanks for the reply!

I did not use email in my case, I uses activity history (created from Email to Salesforce) instead, the report is based on activity history. I just want to add an additional column that the value are substraction from the other 2 columns.
Sonam_SFDCSonam_SFDC
Hi, yes its possible to create a formula on the report - the following thread has a sample formula which you can edit as per your requirement:
https://success.salesforce.com/answers?id=90630000000gxiDAAQ
hy.lim1.3897974166558203E12hy.lim1.3897974166558203E12
Hi Sonam, the thread were showing the formula for 2 different field but i would like to have the difference between values within the same field (highlighted in RED), is there any formula that can calculate the difference between field values?

And one more thing is how can i get the avg date time (highlighted in brown) of each record like show in sample pic below:

User-added image
SFDC LearningSFDC Learning
Hi, Did you find the solution for this issue? 
If yes than please share here .I am having the same problem now.

Thank you