I am trying to use:
SUM(
SELECT(
Inventory[Amount],
([Item ID] = [_THISROW].[ID])
)
)
To Run an accumulative amount, But I want to compare the Item ID and Item Color
Item ID: 01, 02
Item Color: Red, Blue
All Counts 0
Input 3 for 01, Blue
Input 2 for 01, Red
Input 5 for 02, Blue
Input 1 for 02, Red
Current Counts:
01, Blue = 3
01, Red = 2
02, Blue = 5
02, Red = 1
Is there a better way, I am lost. Thanks for any help in advance
Solved! Go to Solution.
SUM(
SELECT(
Inventory[Amount],
AND(
([Item ID] = [_THISROW].[ID]),
([Color] = [_THISROW].[Color])
)
)
)
https://help.appsheet.com/en/articles/2347624-and
It seems like if you create an Inventory table with this definition
id: UNIQUEID(), itemId, color, amount.
Then this seems exactly what you want without any expressions.
I have that table already, but I am using another table to update the amounts!
Thanks for the great things that you have done for me I am trying to use [ 02 Blue =5 ] [01 Red = 2 ] thanks I still need your assistance with the matter full Big possible please thrive tome thanks again God blesing all of you and protect you amen
Hi thrive tome please
SUM(
SELECT(
Inventory[Amount],
AND(
([Item ID] = [_THISROW].[ID]),
([Color] = [_THISROW].[Color])
)
)
)
https://help.appsheet.com/en/articles/2347624-and
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |