compare and update a stock value

[pawe84]

Hi everyone,

I have this table view (see also attached file, sheet "table_view").

The problem now: I have to compare for each product and customer the current stock value and if the requested quantity or less could be delivered.

E.g.: Product = Monitors; the whole product has only a stock value of 150.
The first customer requested 100, so we are able to deliver 100
after that -> 150-100=50. The 2nd customer wants 75 but now we can only deliver 50 and the 3rd won't get anything because stock is empty now.

The output column should look like this (qty_available).

How to compare stock values?

Thanks for any information.

[manodwhb]

You can do this with tmap by using variables.

[pawe84]

But how to create dynamic variable if you have thousands of products?

Do I have to count my products at first and then I would get the number for my variables?

If this is the data view for each product at first we have to find the current stock value because it's a 1:n join

like this example below.