4 Replies Latest reply on Aug 17, 2018 4:41 AM by chandrakanth k

# Calculate the difference across rows

Hello All,

I have create a pivot table and I need find the difference between payment date & Actual Pay date.

Regards,

Chandrakanth.K

• ###### 1. Re: Calculate the difference across rows

Hi Chandrakanth,

Please check attached file. Is this what you are looking at?

Vijay

• ###### 2. Re: Calculate the difference across rows

Hi Chandrakanth,

Create a calculated field like below to populate NULL with Zero

To get the difference create calculated field like below

For September take an example Actual Date is -4382 and payment date is -2788

so the difference would be -4382-(-2788) = -1604

BR,

NB

• ###### 3. Re: Calculate the difference across rows

Hello Vijay,

Yes this is what I was looking for? but can we do this without creating pivot table? I need find the amount difference between payment date month and actual date monthly.

Find the attached updated workbook.

Regards,

Chandrakanth.K

• ###### 4. Re: Calculate the difference across rows

Hi Naveen,

Hello Vijay,

Yes this is what I was looking for? but can we do this without creating pivot table? I need find the amount difference between payment date month and actual date monthy.

Find the attached updated workbook.

Regards,

Chandrakanth.K