asked on July 19
Hi All,
Please could you assist me.
I have a document table with a radio button and terms field.
I have a total number field below the table and would like to total the totalIncl column when the radio button field (Status) value is Delivered and the terms field value is either 04 - EFT Payment OR
01 - Cashless Device Payment.
This is what I have so far:
=IF(AND(INDEX(Documents.Status,ROW()), "Delivered", OR(INDEX(Documents.Terms,ROW()), "01 - Cashless Device Payment", INDEX(Documents.Terms,ROW()), "04 - EFT Payment"))), SUM(INDEX(Documents.Total_Incl,ROW())),0.00)
Here is the table:
0
0