on 10-19-2015 11:18 PM
I have a column 'standard cost' and I have formula to make QTY * standard cost. then i make runnning total this field. and also tried insert summary but it makes crazy amount, what should be around 20,000 show as 33 million.
The lines showing as group footer lines. group5a and group5b. But I wanted total per each group and they are both off.
Hi Paul,
If you've conditionally suppressed any of your details section, then that could also cause totals to be off.
You'd need to use include the suppression condition in the calculation as well.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are likely not resetting the running total back to zero correctly.
In your case it likely needs to be set so that it resets for each Group 5.
Ted
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.