Sum in Footer not exporting to Excel (1 Viewer)

taifoor · Aug 28, 2017

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 · Aug 28, 2017

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

taifoor · Aug 28, 2017

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

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 · Aug 28, 2017

See my formula, it is different!

taifoor · Aug 28, 2017

arnelgp said:
See my formula, it is different!

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 · Aug 28, 2017

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

taifoor · Aug 28, 2017

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

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

Sum in Footer not exporting to Excel (1 Viewer)

taifoor

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

taifoor

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

taifoor

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

taifoor

Registered User.

Similar threads

Users who are viewing this thread