I try to apply a sort on a count with a Filter (Cell E30 option1), it fails. Have also tried to make the Filter in cell D30 does not work well.
The sorting does work if I do not put in the filter (Cell E30 option2), here is a solution?
Cel D30 =NL("Rijen";"Planningsregels";"Verkoper";"-=NL(""Tellen"";""Planningsregels"";""Verkoper"";""Verkoper"";NF(;""Verkoper""))";"*")
Cel E30 (optie1) =NL("Tellen";"Planningsregels";"Verkoper";"Verzendwijze";$E$4;"Leverweek";$E$5;"Verkoper";$D30;"Bedrijf=";$E$3;"Monteurs";"<>@*veras*";)
Cel E30 (optie2) =NL("Tellen";"Planningsregels";"Verkoper";"Verkoper";D30)
Date
Votes
12 comments
-
Jet Reports Historic Posts Yes, there is!
Here is a discussion very much related to your question –> https://community.jetreports.com/viewtopic.php?f=23&t=2109
I hope that helps. -
Jet Reports Historic Posts Sorting with sum works, but counting does not work sorting
-
Jet Reports Historic Posts Are you able to run this sample?
-
Jet Reports Historic Posts Sorting occurs on the total of the rules in the table and not the number of lines contained in the Filter
-
Jet Reports Historic Posts Hello -
I have added the necessary quote changes to the sorting function.
I have also added a column showing the value that is being used for the sort. The report was showing this value:
=NL("Tellen","Planningsregels",,"Verzendwijze",$E$4,"Leverweek",$E$5,"Verkoper",$D7,"Bedrijf=",$E$3,"Monteurs","<>@*veras*",)
but is sorting by this value:
=NL("Tellen","Planningsregels",,"Verkoper",D7)
Because of the filters involved, these two numbers can be very different.
Does that help? -
Jet Reports Historic Posts I make a mistake, but how do I get the sorting on the filtered outcome?
-
Jet Reports Historic Posts If you want to sort by the values in column E, you need to use that same function as part of your sort.
Since that function includes cell references, those references need to be outside of the quotation marks (otherwise, they are a just text… not cell references).
Take a look at the attached. -
Jet Reports Historic Posts When running, I get the following error message:
Excel kon '=NL("Tellen","Planningsregels",,"Verzendwijze",MO,"Leverweek",2017-01..2017-08,"Verkoper",NF(,"Code"),"Bedrijf=",VKTBL Logistiek,"Monteurs","<>@*veras*",)' niet evalueren. -
Jet Reports Historic Posts Sorry about that. I am accustomed to my regional settings, in which commas are used to separate parameters.
I've replaced all the commas in cell F7 with semicolons.
-HP -
Jet Reports Historic Posts I'm still getting an error message:
Excel kon '=NL("Tellen";"Planningsregels";;"Verzendwijze";*;"Leverweek";*;"Verkoper";NF(;"Code");"Bedrijf=";*;"Monteurs";"<>@*veras*";)' niet evalueren. -
Jet Reports Historic Posts Replace cell G7 with:
="-=NL(""Tellen"";""Planningsregels"";;""Verzendwijze"";"""&$E$4&""";""Leverweek"";"""&$E$5&""";""Verkoper"";NF(;""Code"");""Bedrijf="";"""&$E$3&""";""Monteurs"";""<>@*veras*"")" -
Jet Reports Historic Posts Thanks it works
Aart
Please sign in to leave a comment.