Hello,
I have scoured the search engine but have been unsuccessful in finding a solution for my problem. I am trying to sort by the sum of all sales lines within a posting date range for each designer. I have the following formula:
$C$3= designer
$C$2= posting date range=NL("Rows","Sales Invoice Line","Shortcut Dimension 1 Code","-=NL(""Sum"",""Sales Invoice Line"",""Amount"",""Shortcut Dimension 1 Code"",$C$3,""Sell-to Customer No."",""*"",""Link="",""Sales Invoice Header"",""Sell-to Customer No."",""=Sell-to Customer No."",""Posting Date""",$C$2)
I had this setup initially unsorted which explains why I used link= to calculate the sum of sales lines that occurred during a specific posting date range, not sure if using the link= in this instance is causing this not to work. :?:
Any input would be much appreciated :D
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
Your formula is almost correct.=NL("Rows","Sales Invoice Line","Shortcut Dimension 1 Code","[color=#FF0000]-=NL(""Sum"",""Sales Invoice Line"",""Amount"",""Shortcut Dimension 1 Code"",$C$3,""Sell-to Customer No."",""*"",""Link="",""Sales Invoice Header"",""Sell-to Customer No."",""=Sell-to Customer No."",""Posting Date"""[/color],$C$2)
The Formula that would work is
nl("Rows","Sales Invoice Line","Shortcut Dimension 1 Code","-=NL(""Sum"",""Sales Invoice Line"",""Amount"",""Shortcut Dimension 1 Code"",$C$3,""Sell-to Customer No."",""*"",""Link="",""Sales Invoice Header"",""Sell-to Customer No."",""=Sell-to Customer No."",""Posting Date"",$C$2)","*")
if you look at the last few characters you find the error.
1. You're missing the last bracket for your Link Formula, as well as a Quotation mark
2. even though you have the Link formula you still need to have a Filter associated, so just use * for all results
Please sign in to leave a comment.