Flag Debt Amt more then L8M Sales customer as risky customer

[paulyeo11]

Hi All

How to Flag when Debt more then Sales ? i am able to create the script in table.

When I try below script for partial load , it return error :-

((Sum(if(Month_n<'8',sales)))-(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)) >0,Yes) as Flag,

So that i can flag customer who debt more then sales as risky customer.

Paul