Hi there,
I'm trying to create a report that list all sales quotes that are above X value. The problem that I'm having is that the amount can only be seen in the sales line, while all the other Information that I need are in the sales header.
By reading through similar threads, I've put together this formula (I've also attached my file)
=NL("Rows","Sales Header",,"+No.",Options!$D$5,"Document Type",Options!$D$6,"order Date",Options!$D$7,"=NL(""sum"",""Sales line"",""Line Amount"",""Document No."",NF(,""No.""))",">40000")
But it still spits out quotes under the set value.
Can someone tell me what I'm doing wrong? Thanks in advance!!
Date
Votes
1 comment
-
Jet Reports Historic Posts I had this same problem, but the Jet Reports support team showed me the NUMBER& and DATE& functions. I guess they are not documented yet.
According to support, when you do a "calculated" field (your NL(""SUM""…)), Jet Reports does the compare alphabetically. To tell Jet Reports that you want to compare numerically, you have to use "NUMBER&" before the filter.
For example=NL("Rows","Sales Header",,"+No.",Options!$D$5,"Document Type",Options!$D$6,"order Date",Options!$D$7,"=NL(""sum"",""Sales line"",""Line Amount"",""Document No."",NF(,""No.""))","NUMBER&>4000")
I've never used the DATE&, but I would assume that it works the same way.
Please sign in to leave a comment.