I want to build a rolling cashflow with a forcast element. I am thinking having a pivotal "This Month" field then fields named like "ThisMonthplus1" ; "ThisMonthminus3" ect up to 12 months behind and 6 months in front.
If I set up "ThisMonth: Format$([DatePaidDue],"yyyy mm"; and Start the figures fields with PayThisMnth: IIf([Mnth]=(Format(Date(),"yyyy mm")),[AmountPaidDue],0) the functions all work and I get the figures I need in the field.
However, if I then go to figures field 2 and use the same formatting but add +2, eg: PayIn2Mnths: IIf([Mnth]=Format(Date(),"yyyy mm")+2,[AmountPaidDue],0);
I get data mismatch error messages, or no figures. Any ideas.
If I set up "ThisMonth: Format$([DatePaidDue],"yyyy mm"; and Start the figures fields with PayThisMnth: IIf([Mnth]=(Format(Date(),"yyyy mm")),[AmountPaidDue],0) the functions all work and I get the figures I need in the field.
However, if I then go to figures field 2 and use the same formatting but add +2, eg: PayIn2Mnths: IIf([Mnth]=Format(Date(),"yyyy mm")+2,[AmountPaidDue],0);
I get data mismatch error messages, or no figures. Any ideas.
