This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello,I have the following 2 related tables, Inventory and Tally
Sheet.Inventory: Tally sheet: I want to add the tally sheet's
'TallyQty', to 'ItemSumQty' in Inventory if the values is In at
'InOrOut', and minus 'ItemSumQty' if the value of 'InOrOut'...
Hi, Thank you so much for the help.Thanks to your help I was able to get
this formula which worked"[InitialStock]
+SUM(SELECT(Tally[TallyQty],AND([InOrOut]="In",[ItemName]=[_THISROW].[ItemName],[LotNumber]=[_THISROW].[LotNumber],[Customer]=[_THISROW]...
Thanks, but the cell now always returns the value as a negative
number.SUM(Select(Tally[TallyQty, [ItemName] =
[_Thisrow].[ItemName]))NUMBER(ANY(SELECT(Inventory[ItemSumQty],AND(TEXT(Tally[Customer])=[_THISROW].[Customer],TEXT(Tally[ItemName])=[_THIS...
