AnsweredAssumed Answered

Calculation for a Field only working on first record

Question asked by MichaelShea_1 on Nov 9, 2014
Latest reply on Nov 9, 2014 by philmodjunk

Title

Calculation for a Field only working on first record

Post

Hello;

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))

Outcomes