I am trying to generate an income and expense statement for each department in our organization. I would like a tab for each department. Can someone help me understand how to use the NL Sheets function to do this? Thanks!
Date
Votes
3 comments
-
Jet Reports Historic Posts So it depends on what table the departments are in in your database. If you were using Nav and deparment was Global Dimension 1, then you could create an NL(Sheets) formula like this:
=NL("sheets","dimension value","code","Global Dimension No.",1)
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts I am using NAV. We have 70+ departments. Can I use a range in the formula to generate only a selection of the departments?
-
Jet Reports Historic Posts Sure! I'm not sure the type of range you mean, but there are many ways to filter in Jet Reports. If you wanted all departments from ADM to SALES, you would do something like this:
=NL("sheets","dimension value","code","Global Dimension No.",1,"code","ADM..SALES")
See the Jet Report filtering reference here for more ways to filter:
http://help.jetreports.com/11.0/Essentials/index.html?Filtering.html
Does this help?
Regards,
Hughes
Please sign in to leave a comment.