So I have been working on a user input filter based dashboard. The goal of the app is to assist in production planing activities.
The structure is straightforward: select open orders from a enumlist and specific columns in a table will change to reflect the quantities associated with the selected orders I have all my filters working fine but the I cannot get enumlist to SUM.
The formula for my filtered column is as follows SUM(SELECT([Ref column of a filtered slice][Quantity],[Product Id]=[_THISROW].[Product Id]))`
If i tick off one value in the enumlist I see the appropriate value in the appropriate field but if I start to tick off multiple items in the list the values go back to 0.
The structure of this app is based on the Order Sample app. There are 3 tables, Orders, Order Details, and Inventory all with ref. I have tried both both virtual and non-virtual columns with the results being the same.