Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Problem to solve in my Application for inventory calculation...
I have a Table like this:
Time Inventory Hours in Stock
Incoming 08:00 10
Outgoing 11:00 5 03:00
Outgoing 15:00 3 07:00
Incoming
How i can calculate the "hours in Stock" and the "nventory" fields?
Hi,
Can you make a manual result that you looking for?
Regards,
Sokkorn
i want to calculate inventory like this:
10 - outgoing(5) =5 - outgoing(2) =3 ..
and the "Hours in Stock " like:
08:00 to 11:00 = 03:00
08:00 to 15:00= 07:00
Hi,
Use function ABOVE().
Edit: Example for Inventory Expression: Inventory - ABOVE(Inventory)
Regards,
Sokkorn