I need some help with a set analysis expression that I can't build by myself.
Here is the deal :
- In one hand, I have some products in my stock. Each product has its own "p_id", and a reference "ref"
- On the other hand, I have some wishes "w_id" from customers on differents references "ref"
LOAD * inline [p_id,ref
LOAD * inline [w_id,ref
The fact is that some wishes will not be satisfied because I have not enough stock of the wish reference
My problem is to evaluate with a single expression the number of wishes that could be satisfied. In the example above, it would be 3 (2 wishes for the "REF A" and 1 wish for the "REF B").
I don't want to use a graphic (I know how to do that).
I'm sure it's possible, but I really don't know how ! Thx for your help.