filter met onjuiste tekens komt van NF (; "" Stad ""); Hoe kan ik dit oplossen
Celinhoud: ="-=NL(""Som"";""Verkoopfactuur"";""Bedrag"";""bedrijf="";"""&$B$3&""";""Boekingsdatum"";"""&$S$3&".."&$S$4&""";""Klantnr."";"""&"<>"&"*00000"&""";""Plaats"";NF(;""Plaats"");)"
Hello Aart -
Where are you using the NF(;""City"") function? I see NF(;""Location"") but not City.
"- = NL (" "Sum" ";" "Sales invoice" ";" "Amount" ";" "company =" ";" "" &$B$3&"" ";" "Posting date" " ; "" "&$S$3&".."&$S$4&" ""; "" Customer # ""; "" "&" <> "&" * 00000 "&" ""; "" Location ""; NF (; "" Location "");) "
-----
Waar gebruikt u de functie NF(; ""Stad"")? Ik zie NF(; ""Plaats"") maar niet Stad.
it is not ""Stad"" but "Plaats"
the formula is good
but there are special characters in it
Ongeldige filter "AALST (LIMB.)".
Perhaps this will work:
"- = NL (" "Sum" ";" "Sales invoice" ";" "Amount" ";" "company =" ";" "" &$B$3&"" ";" "Posting date" " ; "" "&$S$3&".."&$S$4&" ""; "" Customer # ""; "" "&" <> "&" * 00000 "&" ""; "" Location ""; ""@@""&NF (; "" Location "");) "
perfect, you earned a pie
do you have an option to make reporting faster? He retrieves a lot of data Lead time is now 33 minutes
Glad it worked, Aart.
Improving speed is an interesting topic. There are some practices that can help.
For example, there are those in the Improving Report Performance article.
There may be some useful hints in the Best Practices (and for GL reports)
Obviously, ensuring that you are using the latest release can be helpful.
Any report that includes a sort by sum (like you are using) will require longer run times... a large number of records must be examined and calculation performed to create the values by which you are sorting.
Maybe other users out there have ideas about speeding up reports?