Set analysis involving <>

[Anonymous]

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.

[jagan · Accepted solution]

Hi,

Try this

=(Sum({<DAYS_LATE={'>1'}>} PRINC_BALANCE)/sum(PRINC_BALANCE)) * 100

Regards,

Jagan.

[Anonymous]

Awesome! thanks Jagan