the data below shows me what i have invoiced and what has been paid
I am trying to return the net amount only if the invoice has been paid
the 2 ways i have tried either give me all the same results ie net amount and exp1 even if the paid has not been ticked
Expr1: IIf(Not IsNull([paid]),[Net Amount],0)
Expr2: IIf([paid]="YES",[NET AMOUNT],0)
thanks
steve
find invoice find invoice
I am trying to return the net amount only if the invoice has been paid
the 2 ways i have tried either give me all the same results ie net amount and exp1 even if the paid has not been ticked
Expr1: IIf(Not IsNull([paid]),[Net Amount],0)
Expr2: IIf([paid]="YES",[NET AMOUNT],0)
thanks
steve
find invoice find invoice
Net Amount | Expr1 | Paid |
---|---|---|
12740 | 12740 | Yes |
8200 | 8200 | No |
1080 | 1080 | Yes |
1080 | 1080 | Yes |
3240 | 3240 | Yes |
540 | 540 | No |
1755 | 1755 | Yes |
5800 | 5800 | Yes |
4170 | 4170 | No |