Hi,
i want to make a list of projects where the total cost of this project are filtered. Example < €50.000,-. These total cost are a sum of a field in an other table. How can ik do this?
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment So basically I think you could do something like this:
=NL("Rows","Job",,"=NL(""Sum"",""Job Ledger Entry"",""Total Cost ($)"",""Job No."",NF(,""No.""))","NUMBER&>50000")
It sounds like you might need a few more filters than this, but hopefully this gets you on the right path. This will only work with Navision data sources. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi,
Can you be more specific about what tables you are talking about and how they are linked? It will be easier to create an example of how to do it this way.
Regards,
Hughes -
Jet Reports Historic Posts In my case i have a table 'jobs' and a table 'job ledger account'. The key is the projectnumber. Now i want to filter the first table with a subtotal of the second table. For example i want all the projects with material costs over the € 50.000,-. This material costs can i find with a NL(sum) in the second table with a specific filter.
At this moment i make a collum visible or not if it meet certain requirement and i use the excel function =subtotal(109,…). -
Jet Reports Historic Posts YES, its works. I don't know excactly what happens in the formula. That sould i analyse later. Thanks
Please sign in to leave a comment.