Hello all,
I'm trying to run a cummalative total for different sections of a report. It sounds simple enough by creating an empty column next to the Jet Reports data like this:
Qty to Ship
S2 empty | T2=Empty
S3 190 | T2+S3 =190
S4 200 | T3+S4=390
S5 120 | T4+S5=510
S6 340 | T5+S6=850
S7 1000| T6+S7=1850
S8 1850
This works for most of the report but all of a sudden I find places where the formula skips a beat like this:
=+T16+S17
=+T17+S18
=+T17+S19
=+T18+S20
There are no hidden lines, just a simple formula. Sorry for the poor formatting. I've attached some screen shots of the problem.
Any ideas?
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
Nothing obvious is standing out to me from the screen shots. I'm wondering if this has something to do with the structure of your replicators. Can you attach the report in Design mode?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
i think you're on to something here. I tried tinkering with my row counts and wound up getting the right sub-totals, but my part numbers were also broken up. (See Word Doc Example.)
I put things back the way they were and sent the report in Design Mode. Any advice you could give is greatly appreciated.
John -
Jet Reports Historic Posts Hi John,
So this doesn't quite work because of how replicators work and how they copy down groups of rows (it gets kind of complicated to explain here). Basically though I think you can achieve what you are trying to with a sum formula in cell S14 like this:=SUM($R$13:R14)
Note it is very important that the reference to $R$13 is absolute so that it doesn't change when the rows are copied, whereas the reference to R14 is relative so it is updated for each row. Does that work for you?
Regards,
Hughes
Please sign in to leave a comment.