Calendar Input Box

[#1]

Hi All,

I need to make a chart counting the no. of records that is outstading based on the calendar input box.

I want the chart looks like this:

Status	Site	Current	1-30 Days	Over 30 Days	Over 60 Days	Over 90 Days	Over 150 Days	Over 240 Days	Total
Open
Released
Grand Total

the formula

= date input - Shipmentdate

current = <0

1-30days = >0<=30

Over 30days = >30<=60

.. and so on

Please see attached file.

Thanks

[Gysbert_Wassenaar]

See attached qvw. Is that what you need?

[#3]

Yes, Just like that! But I need it to be fix 'Over 240 Days' Is there any way for that to be implemented? Thanks

[Gysbert_Wassenaar]

Change the calculated dimension to:

=if(vDate-ShipmentDate<0,dual('Current',-1), if(vDate-ShipmentDate<240 ,class(vDate-ShipmentDate,30),dual('Over 240 days',9999)))

[#5]

Hello, Thanks for the reply.

Another question please, I need it to be 1< x <= 30 because current is already counted as 0, is this possible to be achieved?

[Gysbert_Wassenaar · Accepted solution]

=if(vDate-ShipmentDate<=0,dual('Current',-1), if(vDate-ShipmentDate<=240 ,class(vDate-ShipmentDate,30,'days',1),dual('Over 240 days',9999) ))

[#7]

Thank you!