0

Sum of Sales for Customers with Country Code

Nutzer

July 19, 2018 11:23

None

Follow

Dear Guys,

i need help to build up some table.

Sum = all customers sales amount with "VK TEXTCODE" DN but listed with countrys between fix date.

the result must be look like for example:

Argentinien - 50.000 €

Chile - 35.000 €

...and so on

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Harry Lewis July 19, 2018 14:41

  Hello Nutzer -

  If I understand correctly, you want the sum of the Amount field in the Cust. Ledger Entry table for each customer where that customer's Country/Region Code in the Customer table matches a record in the Country/Region table where the custom field VK Textcode is set to DN

  I would think that this should do that:

  

  

  

  

  I've included table and field numbers to avoid any confusion about the names of the tables and fields.

  You can add a date filter to the NL(Sum) function for the date range you want.

   

  The results:

  

  Edited by Harry Lewis July 19, 2018 14:43
• 0
  
  Nutzer July 20, 2018 10:30

  Dear Harry,

  thanks for quick help, i think it works, but it loads since 2 hours without results at the moment,... it is normal ?

• 0
  
  Nutzer July 20, 2018 10:31

  maybe there are a faster solution?

• 0
  
  Harry Lewis July 20, 2018 14:07

  Hello Nutzer -

  How many records - matching your date range criteria, of course - are in the Cust. Ledger Entry table?

  Are you using a Web Services connection?

  

  or a SQL Server connection?

  

  What speed of connection is reported when you test it?