Sum in Footer not exporting to Excel (1 Viewer)

T

taifoor

Registered User.

Local time

Tomorrow, 00:53

Joined

Jul 16, 2015

Messages

62

• Aug 28, 2017

• #1

Dear All,

I have to sum an amount column in report footer. When is use Sum([Amount]) formula, then it exports ok. But when i use Nz(Sum([Amount]),0) it do not exports to excel. I think its beacuse Nz is not supported by Excel. So my obejctive is to sum in footer and show 0 if all values of amount are null. Please guide.

Again please note that i want that sum in footer to be exported to excel.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 04:53

Joined

May 7, 2009

Messages

19,229

• Aug 28, 2017

• #2

Can u use Sum(Nz([Amount],0))

 

T

taifoor

Registered User.

Local time

Tomorrow, 00:53

Joined

Jul 16, 2015

Messages

62

• Aug 28, 2017

• #3

arnelgp said:

Can u use Sum(Nz([Amount],0))

Click to expand...

I also tried that but its not exporting to excel. I have also tried IIf(isnull(sum([Amount])),0,sum([Amount])) but no luck.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 04:53

Joined

May 7, 2009

Messages

19,229

• Aug 28, 2017

• #4

See my formula, it is different!

 

T

taifoor

Registered User.

Local time

Tomorrow, 00:53

Joined

Jul 16, 2015

Messages

62

• Aug 28, 2017

• #5

arnelgp said:

See my formula, it is different!

Click to expand...

Yes. I know its different. U suggested to use Nz with amount not with sum. But its not working as using Nz is the main problem.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 04:53

Joined

May 7, 2009

Messages

19,229

• Aug 28, 2017

• #6

U think the problem is not Nz. I tested with count() and it did not show in excel using Outputto.

 

T

taifoor

Registered User.

Local time

Tomorrow, 00:53

Joined

Jul 16, 2015

Messages

62

• Aug 28, 2017

• #7

arnelgp said:

U think the problem is not Nz. I tested with count() and it did not show in excel using Outputto.

Click to expand...

Right. So I need any solution ...... I am trying by myself too but still not getting lucky