Highlighting cases in advance

[nevilledhamsiri]

As per the Debtors Age, I need to highlight cases of which Debtor code='IND'  & as & when  they get closer to 60 days with a red flag. (If they just pass 56 days, the signal should start to appear so that it will be an eye opener for the deb collector to do the needful. For other codes when they get closer to 105 days, the signal should appear. (As per the system, automatic cancellations will be happened when these two criterians are exceeded. Also at times due to  system failure, may be  there could be balances being appeared even after exceeding the given restrictions. If those cases are noted they too be reflected being highlighted.

Dear all, please propose me  some logical statement to cover this up either in the front end or in a chart.

Thanks in advance

Neville

[m_woolf]

I changed the Background color expression for the DAYS_FLAG field.

See the attached qvw

[nevilledhamsiri]

Hi, M W

Could you please send me the expression for each colour since I cannot view your data. (Note I am using  a personnel edition)

Thanks a lot.

[m_woolf · Accepted solution]

=if(DEBTOR_CODE='IND' and DAYS_FLAG>=56,lightred(),

if(DAYS_FLAG>=100,lightred()))