Excel Value Sum of Column
-
- Posts: 14
- Joined: Tue Oct 12, 2021 2:45 pm
Excel Value Sum of Column
Is there a way to sum the value of a column so that the exported Excel file shows the formula (Excel Value) of a column that is not static? (I want the part in yellow to calculate using Excel formulas, but the part in blue may increase or decrease in rows.)
- Attachments
-
- ExcelValuesSumColumn.PNG (26.26 KiB) Viewed 6688 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Excel Value Sum of Column
Hello,
Please check the following article:
https://www.stimulsoft.com/en/documenta ... _value.htm
Thank you.
Please check the following article:
https://www.stimulsoft.com/en/documenta ... _value.htm
Thank you.
-
- Posts: 14
- Joined: Tue Oct 12, 2021 2:45 pm
Re: Excel Value Sum of Column
Right, that works for the rows, but I'm looking to do the column. When I put in Sum(C{Line}) I get the value of a random cell (granted, it's in the same column, but I need the sum of the range).
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Excel Value Sum of Column
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
-
- Posts: 14
- Joined: Tue Oct 12, 2021 2:45 pm
Re: Excel Value Sum of Column
In these files, the totals are already there, as calculated in Stimulsoft. We would want to replace these with formulas in Excel.
- Attachments
-
- IncomeStatementReport.Excel.mrt
- (179.55 KiB) Downloaded 44 times
-
- Project1IncomeStatement-parameters.json
- (4.5 KiB) Downloaded 50 times
-
- Project1IncomeStatement-data.json
- (15.37 KiB) Downloaded 52 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Excel Value Sum of Column
Hello,
Please explain, where you use excel formula in your report?
Thank you.
Please explain, where you use excel formula in your report?
Thank you.
-
- Posts: 14
- Joined: Tue Oct 12, 2021 2:45 pm
Re: Excel Value Sum of Column
I would want to use it for the Total Revenues, Total Expenses, etc. See the example above: It would be the yellow highlighted cells.
-
- Posts: 14
- Joined: Tue Oct 12, 2021 2:45 pm
Re: Excel Value Sum of Column
We found a solution: We added in an index column (=0) and section counts. From there we are able to calculate the row numbers of the different sections since the report starts on the same row every time. This works when we only have one project. We are still thinking through how to do this for a multi-project report.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Excel Value Sum of Column
Hello,
You sent data in json, and business objects are used in the report. We couldn't run your report.
First, read the article that was sent to you right away to the end. It is well-written about cell offsets. The formula for the sum of a column looks like this: SUM(C2:C8).
In your case, you should substitute for example like this:
=SUM(B{14}:B{14+dataSource.Count})
14 is a random number, your report does not run to find out the real offset.
Thank you.
You sent data in json, and business objects are used in the report. We couldn't run your report.
First, read the article that was sent to you right away to the end. It is well-written about cell offsets. The formula for the sum of a column looks like this: SUM(C2:C8).
In your case, you should substitute for example like this:
=SUM(B{14}:B{14+dataSource.Count})
14 is a random number, your report does not run to find out the real offset.
Thank you.