2 Replies Latest reply: Oct 1, 2012 7:51 AM by Adotey Kwame RSS

    Set analysis involving <>

    Adotey Kwame

      Hi,

       

      Could there be an ideal and better way to re-write this expression below because i can't get my head around is using set analysis.

       

      sum(if(DAYS_LATE>1,PRINC_BALANCE))/sum(PRINC_BALANCE)*100

       

      Thanks.