Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=if(vDate-ShipmentDate<=0,dual('Current',-1), if(vDate-ShipmentDate<=240 ,class(vDate-ShipmentDate,30,'days',1),dual('Over 240 days',9999) ))
See attached qvw. Is that what you need?
Yes, Just like that! But I need it to be fix 'Over 240 Days' Is there any way for that to be implemented? Thanks
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)))
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?
=if(vDate-ShipmentDate<=0,dual('Current',-1), if(vDate-ShipmentDate<=240 ,class(vDate-ShipmentDate,30,'days',1),dual('Over 240 days',9999) ))
Thank you!