Hi
I have 4 columns and I need to know how many consecutive payments have been missed. The column titles are 'Missed or less payment received then 1</SPAN>'In the columns below there is a '1' if missed.
example
If in August there is a 1 and in Sep there is a 1 but October there is a 0 then i need to show that as 2 consecutive payments.
If in Auguest there is a 0 and in Sep there is a 0 and in October there is a 0 but November is a 1 then need to show 1 consecutive payment
Below is my table, any ideas on how to do this?
<TBODY>
</TBODY><COLGROUP><COL><COL span=3><COL><COL span=3><COL><COL span=3><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
I have 4 columns and I need to know how many consecutive payments have been missed. The column titles are 'Missed or less payment received then 1</SPAN>'In the columns below there is a '1' if missed.
example
If in August there is a 1 and in Sep there is a 1 but October there is a 0 then i need to show that as 2 consecutive payments.
If in Auguest there is a 0 and in Sep there is a 0 and in October there is a 0 but November is a 1 then need to show 1 consecutive payment
Below is my table, any ideas on how to do this?
August</SPAN> | September</SPAN> | October</SPAN> | November</SPAN> | |||||||||||||||||
Payment received August</SPAN> | Arrears balance as at COB 31.08.14</SPAN> | Hidden Arrears</SPAN> | Missed or less payment received then 1</SPAN> | Payment Received September</SPAN> | Arrears balance as at COB 30.09.14</SPAN> | Hidden Arrears</SPAN> | Missed or less payment received then 1</SPAN> | Payment Received October</SPAN> | Arrears Balance as at COB 31.10.14</SPAN> | Hidden Arrears</SPAN> | Missed or less payment received then 1</SPAN> | Payment Received November</SPAN> | Arrears balance as at COB 30.11.14</SPAN> | Hidden Arrears</SPAN> | Missed or less payment received then 1</SPAN> | Difference from July - November</SPAN> | Volume of Accs</SPAN> | Total Number of Missed Payments</SPAN> | Total number of Consecutive Payments</SPAN> | Accounts in Credit as at November 2014</SPAN> |
Full payment received</SPAN> | -£0.01</SPAN> | N</SPAN> | 0</SPAN> | Less than full payment received</SPAN> | £0.00</SPAN> | 1 </SPAN> | Full Payment received</SPAN> | £0.00</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | £0.00</SPAN> | 0 </SPAN> | £0.01</SPAN> | 1</SPAN> | 1</SPAN> | |||||
Full payment received</SPAN> | -£0.01</SPAN> | N</SPAN> | 0</SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | £0.00</SPAN> | 1</SPAN> | 0</SPAN> | |||||
Full payment received</SPAN> | -£0.01</SPAN> | N</SPAN> | 0</SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | £0.00</SPAN> | 1</SPAN> | 0</SPAN> | |||||
Full payment received</SPAN> | -£0.01</SPAN> | N</SPAN> | 0</SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | £0.00</SPAN> | 1</SPAN> | 0</SPAN> | |||||
Full payment received</SPAN> | -£0.01</SPAN> | N</SPAN> | 0</SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | Full Payment received</SPAN> | -£0.01</SPAN> | 0 </SPAN> | £0.00</SPAN> | 1</SPAN> | 0</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL span=3><COL><COL span=3><COL><COL span=3><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>