Use function Sum, Avg, and Count within a script

[#1]

Is it possible to use the functions sum, avg and count in a script (LOAD Customer, Sum (Sales) as Sales, Count (No Order) as controls NB Resident invoice;)?

every time I use one of these functions have an error Espression

thank you

[isaiah82]

Sure, you can use these in a script but you would have to use a GROUP BY clause in your LOAD statement (similar to, but different than sending a GROUP BY clause in an SQL statement.)

Example:

LOAD Customer, Sum(Sales), Count([No Order]) as controls
RESIDENT Invoice
GROUP BY Customer

If your source is a table file, SQL, etc. the syntax may be a little different.  -Isaiah