Month is not highlighting ?

[#1]

HI All,

I have to calculate Balance Amount up to Every Month from Starting on wards to till end of every month whether transactions has done or not on the Basis of Credit & Debit... For Example I have transactions in Jan, Apr,Jun,Jul,Aug...

But user Want to See the Jan Amount only in Feb & March becoz transactions are not done in that months...

Apr Amount Need to be Seen in May becoz transactions are not done in that month...

HOw Can I acheive this any Idea... ?

Find the attached Screen shot...plz help ...

[avinashelite]

Hi Helen,

Can you please provide the sample data.

[#3]

HI Avinash,

I have attached data for 4 customers can you reolve that in above ...plz check...

Regards,

Helen

[#4]

add a new month field which is month + 1 month i.e. Jan becomes feb in the new field and use this for selections?

[#5]

Hai Felim,

If for Example have not done for continuosly for many months , Then it should work, Value you should be carry forwarded by previous months, Can you please do it on the above Data Which I have attached for 4 Customers So that you will Understand...TD_DOC_Amount Should be calculated from TD_DOC_DRCR_FLAG having D & C...Means Debit (Minus) Credit...

please help...

Regards,

Helen