Calculation for a Field only working on first record
I am trying to lookup the current month's mortgage payment date.
From the table in which I am generating this field, I look up the "Lote" for the record and match it to the same "Lote" in the Payments Table. Within the Payments table, there are multiple mortgage payments listed. I am therefore doing a further search for the payment date related to the current month (or a defined variable as in the example below 10/10/2014).
For sum reason, the calculation only works for the first record....and nothing more. I have 500 records.
If(Payments::Lote=Lote; If(Payments::Vencimento= Date ( 10 ; 10 ; 2014 );Payments::Codigo Pagamento;0))