Hi @ all,
I want to create a TOP 10 list of "weekly Sales" So I created the following function:=nl("rows";"value entry";"source no.";"posting date";"110612..170612";"Item Ledger Entry Type";"Sale";"-=nl(""sum"";""value entry"";""Sales Amount (Actual)"";""source no."";NF(;""source no.""))";"*";"Limit=";"10"))
the returned values are correct if i omit the LIMIT= tag. With LIMIT= tag, some values (mid range) are missing.
It doesn't matter if I put a "-" or "+" in Front of the nested NL Link, sorting is always mixed up.
any suggestions?
thanks in advance
Michael
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Michael,
It looks to me like you need to have your filters for posting date and item ledter entry type in your calc formula as well as your main formula. It might look like this:=nl("rows";"value entry";"source no.";"posting date";"110612..170612";"Item Ledger Entry Type";"Sale";"-=nl(""sum"";""value entry"";""Sales Amount (Actual)"";""posting date"";""110612..170612"";""Item Ledger Entry Type"";""Sale"",""source no."";NF(;""source no.""))";"*";"Limit=";"10"))
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
that helps, thank you.
BR
Michael
Please sign in to leave a comment.