Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try this
=(Sum({<DAYS_LATE={'>1'}>} PRINC_BALANCE)/sum(PRINC_BALANCE)) * 100
Regards,
Jagan.
Hi,
Try this
=(Sum({<DAYS_LATE={'>1'}>} PRINC_BALANCE)/sum(PRINC_BALANCE)) * 100
Regards,
Jagan.
Awesome! thanks Jagan