On Thursday, April 28, 2016 at 4:23:26 PM UTC-7, 黄祥 wrote: > > is there a way to update table and calculate using FIFO (First In First > Out) methods? > e.g. > Unit Trade Unit Remaining Subscription Unit NAV Date > 3.000,00 1.000,00 1.000,00 01/03/2016 > 2.000,00 1.000,00 1.000,00 01/02/2016 > 1.000,00 1.000,00 1.000,00 01/01/2016 > let say i have the data above, when user sell the unit (redeem) it will > deduct the remaining subscription unit using FIFO method, the problem i > face is if the user redeem unit is more than remaining subscription unit, > how can the system deduct the remaining subscription unit for the next row? > e.g. query case i don't understand to solve it using web2py > user redeem 1500 unit > expected result > Unit Trade Unit Remaining Subscription Unit NAV Date > 1.500,00 -1.500,00 0,00 01/04/2016 > 3.000,00 1.000,00 1.000,00 01/03/2016 > 2.000,00 1.000,00 500,00 01/02/2016 > 1.000,00 1.000,00 0,00 01/01/2016 > how i can solve it using web2py way? > > thanks and best regards, > stifan >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
