set analysis

[#1]

Hello,

I have display value till the selected year and month-1.

But for 1 specific "item no" there is no entry for 2012 - April. so it is not calculating any value and shows 0.

For 2012-May, there is entry in DB, so it is showing value.

So how to do calculation in such scenario.

I have attached qvw with sample data.