Formula on Totals

Aspose.Cells Product Family
41

Hi,

Please try the latest version: Aspose.Cells for Reporting Services v1.9.0.15.

  1. We have fixed that dynamic formulas calculation error when hiding column(s).

  2. We have fixed that the SUM of footer only sums the last group and not all groups. But the sum of footer sums all details.

Please let us know run result.

If you still face the issues, please post your report file here.

We will check it ASAP.

42

Hi,

Thank you for looking into it, we are still under the process of testing. On the initial note , the dynamic calculation of the formula and hide column issue seems to be working.

However, the totals on the group and the grand total does not seem to function right. We have two footer rows , one to sum up the group totals and the grand totals to sum up all the group totals. These formulae worked right on the excel and it was just displaying the formula on the UI, but now it seems to not work on both the places. We had used &=&=SUM(N9:N9) for the group totals and for the grand totals , we had used SUMIF function to find the string Totals in B9 and add N9's. We did not change any of the formula here.

We were not sure , if we had to change this to something else after the fix or the same formula would work as such. Please let us know , if we should be treating it differently or how it would work ?

Thanks,

Aparna

43

Hi,

The flag(&=&=) is the flag of dynamic formula. e.g. &=&=N{r}+M{r}+L{r}

The flag is the flag of expression. e.g. &=Inspections.Total_Time_Hoursa &=SUM(Inspections.WEEK1)

So, you may use &=SUM(Inspections.WEEK1) for the group totals and for the grand totals.

If you want to use Excel SUM function in exported Excel report, you can directly set =sum(K9:K9) for the totals

(see the screen shot below)

We post here our updated report define file and Exported Excel file in the attached archive. Please refer to it.

Thank you

44

Hi,

We did some more testing , as we wanted the excel formula for the Group and Grand totals on the exported excel, we used =Sum(k9:k9) for both the columns. It does work displaying data on the UI and displaying the formula on Excel. However, the SUM RANGE on the formula for the groups don't seem to be accurate. We had a few groups, and the groups which had fewer rows like 10 or so, did get the range correctly. For the groups that had larger row counts, the range is off. It's off , for both the group totals and the Grand totals. Is there any range limit on the groups ?

May you please assist us here.

Pleae find attached screenshot. In the example, the start range is correct , but the end range is off. Instead of 3514, it is 3507.

Thanks,

Aparna

45

Hi,

We have found the issues for total SUM rows error and fixed them.

Please try the fixed version : Aspose.Cells for Reporting Services v1.9.0.16.

Please let us know your run result.

46

Hi,

The sum on the group and the totals work. Thank you for all your support and help. We appreciate it.

Thanks,

Aparna

47

Hi,


Thanks for your feedback and good to know that your issue is resolved.

Thank you.