have been working on a formula to get a list of the balance Leave hours per 31/12/2012, sorted descending on the balance.
This is what i have constructed:=NL("Rows";"N018 Resource Leave Entry";"Resource No.";"posting Date";"010112..311212";"Work Type";"200VERLOFN";"Resource No.";"*";"Quantity";NL("Sum";"N018 resource Leave Entry";"Quantity";"Posting Date";"010112..311212";"Work Type";"200VERLOFN";"Resource No.";NF(;"Resource No.")))What I want is the balance per resource no. for the specified Work Type. I expect that the problem is in the nested NF-function; i can't seemto get that one right. suggestions are very welcome, since I can't get it to work even after ploughing through a lot of related posts.
Thanks in advance,
Willem
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Willem,
If you're trying to do a calculated filter, which is a filter that is evaluated for each record of the parent formula, you have to quote it and start it with an = like this:=NL("Rows";"N018 Resource Leave Entry";"Resource No.";"posting Date";"010112..311212";"Work Type";"200VERLOFN";"Quantity";"=NL(""Sum"";""N018 resource Leave Entry"";""Quantity"";""Posting Date"";""010112..311212"";""Work Type"";""200VERLOFN"";""Resource No."";NF(;""Resource No.""))")
I don't think this formula can be precisely right since the table and all the filters are exactly the same between the outer formula and the calculated filter, but maybe this will at least help you understand how to create this type of filter. Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Yes that helps! Now I can try to build a better filter.
thanks.
Willem
Please sign in to leave a comment.