0 Replies Latest reply: Sep 8, 2015 3:40 AM by Yeo Poh sai RSS

    Flag Debt Amt more then L8M Sales customer as risky customer

    Yeo Poh sai

      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.