Forum Discussion

ashaikh's avatar
ashaikh
Helper III
9 years ago
Solved

running total

Hello All,   I have one scenario which I am trying to do   I hava table having ticket data.   Ticket No | Data Create | Day| Ticket allotted per day 1 |2017-08-01 | 1 | 26 2 ...
Need Help
Tips and Tricks
ashaikh's avatar
ashaikh
Helper III
8 years ago

Hello Alberto,

 

Let me put my query this way. And i would appreciate if you can help me.

 

Lets not consider me having an anyother table for Ticket Allotment. I am just having one ticket table.

 

Now Ticket allotment is calculated in following way.

Total Number of Ticket Allocated/Number of days in a month.

For Example: September, 800/30 = 26.67 ~ 27

 

So without having Ticket Allotment table is it possible to calculate Running Ticket Allotment.

 

Thanks in Advance