Hi All,
I have 2 customs table, activity and task. A task contains several activities that are linked by a task n°. I want to sum all activity in a task based on a filter on task.
I use the link function because there is a lot of headers, but I tried also the filter function without success.
NL("Rows";"Activity";"Realized Time (h)";"User ID";"XXX";"Date";$F$2;"Type Code";"<>ABS";"Link=";"Task";"Task No.";"=Task No.";"Customer No.";"20001";"Filterxxx";"False")
If I do that, it show all the lines properly.
If I replace "rows" by "sum", it ignores me the link and sum up all the activity lines with the filter user id/date/… that are on activity.
It seems that, with sums it doesn't apply the nested link.
I try in a lot of diffrent way but I'm a bit lost.
Thanks for your help.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
which field should get "summed"?
Or do you mean "Count"?
regards
jetsetter -
Jet Reports Historic Posts It's "summed" for the field: "Realized Time (h)"
-
Jet Reports Historic Posts Instead of using a link=, I would recommend using a NL(Filter), so your NL(Filter) would be to your Task table that creates a list of Customer Numbers with any applicable filters (Filterxxx;False, etc).
Please sign in to leave a comment.