Dear guys, really appreciate any help or advice on this
I have an app with Main Orders, this Main Order can have several Purchase Orders for different (or same provider). Before create a new PO for a provider i need to count previous quantitate of orders for the chosen provider, from a dropdown. Iยดm counting this way
COUNT(
SELECT (TABLEORDERS[ORDERSID], AND([MAINORDERID]=[_THISROW].[MAINORDERID],[PROVIDER]=[_THISROW].[PROVIDER]),FALSE)
)
MAINORDER and PROVIDER are chosen in different dropdowns
The problem is that the app is counting the actual choice! I need the count for previous orders and not include the order I'm creating!
Really appreciate any advice or help on this
Regards
Carlos
Subtract values from a list - AppSheet Help
SELECT(...) - LIST([_THISROW])
User | Count |
---|---|
41 | |
30 | |
29 | |
16 | |
14 |