This should do the job for you
=NL("Sum","G/L Account"',"<what field you want to sum>","<Filter Field 1>",""<Filter Value N>"…)
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello all. I am brand new to this forum so I apologize if this has already been answered somewhere else…
i have created a report that pulls in a specific G/L Account range. Then my Jf/x formula begins with '=NL("Rows","G/L Account"'. This causes every single line within the Account range to be pulled in on a seperate line. I want to be able to sum up the entire range on one line. I believe I need to use the What Sum formula but I cannot get it to work correctly.
Can anyone offer some help with this?
Thanks in advance!
-T
Please sign in to leave a comment.