I have a report that shows Budget versus actual for each period. I want to run this for a given date range and it works fine. My problem is that I want to sum the results year to date. I currently add in a formula after the report runs but I would like to do this in design. I have attached an example here of what I am trying to do.
Any suggestions.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
You could change your rows formula to Rows=2. Then hide the 2nd row by putting Hide in column A of that row. Then you use a cell reference to get only the value you want summed in that row. Then on the right of your replicators you sum that values in that hidden row. This is a little hard to explain. If you attach your report with actual Jet functions in Design mode, then I could probably give you an example if this doesn't make sense.
Regards,
Hughes -
Jet Reports Historic Posts Budget vs Actual by Period.xlsx
File attached, many thanks for your help. I am on vacation for the next 10 days but will pick this up on my return. -
Jet Reports Historic Posts Hi,
Attached is the example of what I mean. Does this help?
Regards,
Hughes
Please sign in to leave a comment.