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.
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.