Skip to Content
0
Former Member
May 22, 2018 at 06:24 AM

Help in Monthly MIS Query report for 'Cumulative This Year' Figures

86 Views Last edit May 22, 2018 at 06:30 AM 2 rev

mpr.png
Hello,

I already have a query report made as Monthly Progress Report. However, there's a bit modification required.

Let's say, We are in 15th date of June 2018. Our production for April was 100 nos. and May was 150 nos. From 1st to 15th June, we have 70 nos. production.

Result Showing:

Figures in Month column are perfect however, 'Cumulative This Year' figures show the figures from 1st April 2018 till date. I.e. (100+150+70) 320 nos.

Result Needed:

Cumulative This Year Should consider the Monthwise figures. It has to be considering figures till last date of previous month. I.e. (100+150) 250 nos.

Please help!

Thanks and regards,

Jitender Bhati

Attachments

mpr.png (3.1 kB)