Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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