I am trying to do a total in a table for total for Day and Total for Week.
I cant figure out the calculation correctly.
Like this. I'll need both calculations.
That usually happens when you have certain functions and empty fields. Off the top of my head, I can't remember which one, but either MULT or PRODUCT will fail if one of the fields is empty.
If you post your formula, it would help narrow things down.
Since you have a fixed number of rows, it is not impossible to have the totals in the same table, however, it is definitely going to make everything a lot more complicated.
I used sum.
It will require significantly more to work in a table.
SUM will automatically sum all rows in a column, so you need to wrap each variable in an INDEX function so it only adds for the current row.
For example,
=SUM(INDEX(Table.Column1,ROW()),INDEX(Table.Column1,ROW()))
The problem you're going to have is that you can't put a calculation in just your "Total For Day" row without affecting the Breakfast, Lunch, and Dinner rows.
Do you have any other suggestions to get what i need?
This is what I do in these situations:
Now you will have row sums in your main table and column sums in the totals table.
To make it look nice, add a "totalsTable" class to the "totals" table, and use something like this in the CSS
.totalsTable .cf-section-header,
.totalsTable th label {
display: none !important;
}
.totalsTable {
padding-top: 0px !important;
}
That will hide the title and heading for the totals table to make it more like it is just part of the main table (if you want that)