SUM If per criteria

[mikegauntlett]

Hi Guys, 

so I have projects and projects have multiple invoices. 

Invoices can either be marked as Paid or Past due. 

I need to get a 'YES' or a 'NO' as to whether the project has a past due invoice. 

How can I write a script in the data load editor to accomplish this? 

so far I have 

IF(Invoice_Plan_Payment_Status = 'Past Due','1','0') as Pay_score,

then 

SUM({<Pay_score={1}, But now have no idea how to run it per project

[chrismarlow]

Hi,

Are you saying you want to be able to identify any project with 1 (or more) overdue invoices?

What are you adding up in the script? Values from all the invoices from the project, or just the overdue ones? Do you want to lose the detail when aggregating in the script, or do you want to keep the detail as well? Have you got massive amounts of data, so you have to aggregate?

If you put some sample lines of data and what you would want shown I might be able to share some other ideas.

Cheers,

Chris.