Script Load where Sum(Amount) Greater Than Zero

wcilliers — Sat, 16 Nov 2024 18:00:14 GMT

Hi All,

I need some help in my load script. I am loading invoice headers and then joining the lines where my amount field gets read from. However, I want to exclude all invoices where the Sum(Amount) = 0.

What is the best way to approach this?

I have tried loading all into a temp table, then loading the fact as a resident from temp table where sum(Amount) > 0 and grouping by DocNumber. But it doesnt seem to work...

Any ideas?

Re: Script Load where Sum(Amount) Greater Than Zero

Taoufiq_Zarra — Thu, 08 Oct 2020 09:33:46 GMT

@wcilliers can you share a sample data and the expected ?

topic Re: Script Load where Sum(Amount) Greater Than Zero in App Development

Script Load where Sum(Amount) Greater Than Zero

Re: Script Load where Sum(Amount) Greater Than Zero