on 09-20-2018 3:09 PM
I have created a formula where I sum a set of times by group. If there is a certain condition, the total is zero. I now want to create a grand total of those sums.
I have tried several ways and can't figure out how to get the final sum. I can't choose that field in running totals and creating a variable and summing that isn't allowed. I have added the "whileprintingrecords" statement.
It won't let me sum a group sum it seems.
Any ideas?
Instead of trying to sum the group sums, look at the data as a whole for the report.
1. Create a formula for the time value that looks something like this:
if <condition for zero> then 0 else {myTable.TimeField}
2. Sum this field. You can use a sum at the group level instead of running totals for your group totals as well as using this for the grand total.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sonia,
Please paste the formula you've created for the Group Sum.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.