Thank you Gerard but I am not sure thats the problem i have.
When I set the formulas just for one company it works but for the other two it doesnt. I mean i can prepare three reports with this formula but only runs for one of the companies and I do not understand why.
any more ideas pls?
thank you in advance.
Rgds,
NACHO
Date
Votes
10 comments
-
Jet Reports Historic Posts Official comment Oh yeah sorry, it's the comma between "Database 1" and "Company=" that is the problem. In the US, we use commas as separators instead of semicolons. I meant to type semicolons, but I accidentally typed a comma there. If you change it to a semi-colon, that error message should go away.
Regards,
Hughes -
Jet Reports Historic Posts Dear all,
I need a report of TOP 20 Customers by quantity saled. I need to run it for three companies (two database). I have done next function and it runs ok just for the first one. In the other two companies, it does not show top customers….
d6:
=NL("Rows";"Item ledger Entry";"source no.";"Source No.";NL("filter";"Customer";"No.";"Customer Posting Group";"CLNNAC|CLNEXT";"COnnection=";$C$2;"Company=";$C$3);"posting date";"010113..311213";"Entry Type";"Sale";"+=nl(""sum"";""Item ledger entry"";""Quantity"";""posting date"";""010113..311213"";""Entry Type"";""Sale"";""source no."";NF(;""source no.""))";"*";"Limit=";"20";"Connection=";$C$2;"company=";$C$3)
e6:
=NL("First";"Customer";"Name";"No.";D6;"Connection=";$C$2;"Company=";$C$3)
f6:
=-NL("Sum";"Item ledger Entry";"Quantity";"Source no.";D6;"Entry Type";"Sale";"Posting Date";"010113..311213";"Connection=";$C$2;"company=";$C$3)
can anyone help me?
Thank you so much. Rgds, NACHO -
Jet Reports Historic Posts Dear Nachoju,
I think you should start with a replicator-formula (NL rows or sheets) for the replication of the companies according to the filter set in C3.
Nested within this replicator use your formulas in which you have to refer to the company in the replicator and not to C3
Hope this helps?
Regards,
Gerard -
Jet Reports Historic Posts Nacho,
Probably, the problem is that you did not include your Connection= and Company= filters in your calc formula like this:=NL("Rows";"Item ledger Entry";"source no.";"Source No.";NL("filter";"Customer";"No.";"Customer Posting Group";"CLNNAC|CLNEXT";"COnnection=";$C$2;"Company=";$C$3);"posting date";"010113..311213";"Entry Type";"Sale";"+=nl(""sum"";""Item ledger entry"";""Quantity"";""posting date"";""010113..311213"";""Entry Type"";""Sale"";""source no."";NF(;""source no."");""Connection="";"""&$C$2&""";""company="";"""&$C$3&""")";"*";"Limit=";"20";"Connection=";$C$2;"company=";$C$3)
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts thank you Hughes but it does not run. It shows me a blank cell :-(
-
Jet Reports Historic Posts Can you post your excel-file. Makes it easier to debug for us I think.
Regards,
Gerard -
Jet Reports Historic Posts Of course. Find it attached. it is the same function for the three sheets but it just run correctly in the first one (company A).
thank you! -
Jet Reports Historic Posts Nacho,
The report you sent does not have the change I suggested. I have made the change and am attaching the report. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts thank you for your time Hughes, but it fails. I receive this message:
Excel could not evaluate: '=nl("sum";"Item ledger entry";"Quantity";"posting date";"010113..311213";"Entry Type";"Sale";"source no.";NF(;"source no.");"Connection=";"Database 1","Company=";"Company 1")'
Rgds, Nacho -
Jet Reports Historic Posts Running!!!
Thank you so much for all your help.
Regards,
NACHO
Please sign in to leave a comment.