Form Script

[pgalvezt]

How Should read into my sxript this?

if(aggr(sum(date(TDFECPRO)-TD_Mora),Num_Tarjeta)= TDFECPRO, Debt * 0,

if(aggr(sum(date(TDFECPRO)-TD_Mora),Num_Tarjeta)>=1 And aggr(sum(date(TDFECPRO)-TD_Mora),Num_Tarjeta)<=30, Debt * 0.01))

I tried:

if(sum(TDFECPRO - TD_Mora)= 'TDFECPRO',Debt * 0),

if(sum(TDFECPRO - TD_Mora)>=1   And  sum(TDFECPRO - TD_Mora)<=30, Debt * 0.01) as RER

But Nothing Happens.

Thank you

[pljsoftware]

Hi,

have you try to use Group By in your script?

Load

.....

if(....) as RER

Resident Table

Group By Num_Tarjeta

Regards

Luca Jonathan Panetta

PLJ Software

[sebastiandperei]

Pgalvez, if I understand, you need to put these expression in a field in the script. Please, say me if im wrong.

For do that, you (or we, to help you) need to know the data structure and format. Many times, the data isn't related in the tables like are in the expressions, of the final app.

Could you send us a reduced copy?