Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I made this little script to see how much money you could save.And it appears that this var $(situation) is not changing at all
at this line : let $(situation) = FieldValue('S1',$(a)) ;
let $(situation) = -200;
for a=1 to num($(count_month))
RVNUS:
LOAD *,
DATE_PAIE as ID_Date
;
LOAD
*,
$(situation) + MONTANT_REVENUS as S1,
monthstart(MonthStart($(date_depart)) + (($(a)-1)*31) ) as DATE_PAIE
RESIDENT REVENUS_TMP1;
let $(situation) = FieldValue('S1',$(a)) ;
TRACE Nlle situation = $(situation) ;
TRACE $(a) ;
NEXT
I've made this, just for fun and it's not fun anymore....
Try declare your variable:
LET situation = -200.
When use value of variable, you set $(situation):
$(situation) + MONTANT_REVENUS as S1,
When get value:
situation = FieldValue('S1',$(a)) ;