I’m trying to make a very simple POS system.
The just want to be able to tick a few items like Water, Apple and get a sum for the total price for the two.
I have a Stock table with Items as text format and Price as Price format.
I have a sales table with Items as enumlist with validation Stock[Items] and Total as Price format with formula SUM(SELECT(Stock[Price], IN([_THISROW].[Items], Stock[Items])))
i got the above formula from another thread, but it seems to be summing the prices of all the stock and not just the ones i have selected on the form.
Any one know how to fix this?