Help Please.

AppSheet AppSheet Q&A
,
1

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

2

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.

3

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

4

I have that table already, but I am using another table to update the amounts!

5 
SUM(
  SELECT(
    Inventory[Amount],
    AND(
      ([Item ID] = [_THISROW].[ID]),
      ([Color] = [_THISROW].[Color])
    )
  )
)

https://help.appsheet.com/en/articles/2347624-and

2 Likes
6

Hi thrive tome please