Hi, I have an App that scans the material that receiving in my warehouse and too scan the delivery to the assigned carrier. When we scan it, the app shows what carrier he will receive.
So, when the material is delivered I did create a module for this, in this module first the user has to select the correct carrier and if he doesn’t do it the app does not allow scanning. this allows continuous scanning of the same carrier
what I try to do now is create a virtual column that shows the count of all skid of the same carrier that remains in the warehouse, these must be status “load Recibido” or “load in Transit”
example:
I am lost with the formula for this, as this need filter only the load (rows) that have a status of In transit or receiving but not others status.
thank you for your help
Solved! Go to Solution.
you’re awesome, the formula works perfectly!!
the scan to delivery is another table but just relate the virtual column with this formula:
and now:
thank you very much, solved!!
If I understood correctly, maybe something like this:
COUNT( FILTER(
loads ,
AND(
[carrier] = [_THISROW].[carrier] ,
IN( [status] , LIST( "load recibido" , "load en transito" ) )
)
) )
you’re awesome, the formula works perfectly!!
the scan to delivery is another table but just relate the virtual column with this formula:
and now:
thank you very much, solved!!
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |