0 Replies Latest reply: Sep 8, 2015 3:40 AM by PAUL YEO RSS

    Flag Debt Amt more then L8M Sales customer as risky customer

    PAUL YEO

      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