Hello,
I am creating a report that breaks out total expense for an award by G/L account by office number. I have successfully created the report for all of our offices together. I am having trouble replicating this out by office. I am building out the
=nl(sheets formula and it is successfully replicating the sheets. It is not however breaking the cost out by office. It is just creating multiple sheets with the same dollar amounts that are in the all offices total report.
I appreciate the help!
Thanks,
Tom
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Tom,
It sounds like you aren't actually referencing the result of the NL(Sheets) formula in any of your other formulas. Usually when you use NL(Sheets) to replicate sheets, you need to reference the result of the NL(Sheets) in your NL(Rows) replicator(s) and sometimes in other functions like NL(Sum) as well depending on how the report is structured. Are you doing this?
Regards,
Hughes
Please sign in to leave a comment.