What causes the running total to be so off?
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.