Hi All,
I have a report in which I use a NL Column=3 function to bring back Actual amounts, Budget amounts, and then Total both for a range of fund numbers. After the last column I would like to have a total column which sums all actual and budget amounts for all the returned funds, but I can't figure out how to get the total for all funds to work. Since the NL column function will return multiple lines I cannot hard code which cells I want to sum, and I can't sum across all colums since I have already included a sum function in the third column of each NL Column=3 function.
Can anyone give any helpful ideas? I have attached an example in case that helps explain what I'm trying to do.
Thanks in advance for any ideas!
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi DMDG,
I think the answer you're looking for is probably the Excel SUBTOTAL function. If you do =SUBTOTAL(9, [Range]) then it will sum all values in [Range] except values from other SUBTOTAL functions. So you could replace your existing SUM functions with SUBTOTAL functions and then do a SUBTOTAL function to get the totals across the entire columns. Does that work for you?
Regards, -
Jet Reports Historic Posts Hi fhilton,
You nailed it! :D I was not aware of that functionality of the subtotal function! Such a simple solution. That's what I was looking for! Thank you!
DMDG
Please sign in to leave a comment.