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.