Counting

[CarlosP]

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

[dbaum]

Subtract values from a list - AppSheet Help

SELECT(...) - LIST([_THISROW])