Is it possible to sum corresponding values fr...

(KOIN BUSYNESS) #1

Is it possible to sum corresponding values from an EnumList in a table such as below?

(Levent KULAÇOĞLU) #2

@KOIN_BUSYNESS

In a virtual column you can use below expression: SUM(SELECT(Tablename[COST],[CATEGORY]=[_THISROW].[CATEGORY]))

(KOIN BUSYNESS) #3

@Levent_KULACOGLU This is the error message I get:

Cannot compare Text with List in ([CATEGORY] = [Vkey].[CATEGORY])

(KOIN BUSYNESS) #4

I tried it, but I still have some challenges with the summation. Kindly assist. with the expression

(Levent KULAÇOĞLU) #5

@KOIN_BUSYNESS can you add levent@able3ventures.com as a co-author to your app so that I can check? Thnx.

(Levent KULAÇOĞLU) #6

@KOIN_BUSYNESS may I ask what is [Vkey]?

(KOIN BUSYNESS) #7

@Levent_KULACOGLU Vkey is the primary key in that table

(Levent KULAÇOĞLU) #8

@KOIN_BUSYNESS what’s the column type for [Category]?

(KOIN BUSYNESS) #9

@Levent_KULACOGLU

LIST It’s a list of food Categories

(Levent KULAÇOĞLU) #10

@KOIN_BUSYNESS

Try this:

SUM(SELECT(TableName[COST], IN([_THISROW].[CATEGORY], TableName[CATEGORY])))

(KOIN BUSYNESS) #11

@Levent_KULACOGLU

Thank you, will feedback soon

(KOIN BUSYNESS) #12

@KOIN_BUSYNESS

please check this link and see if you can apply the expression you were teaching me. I want to be able to select a list of fruit names and then get their total sum for those select.

appsheet.com - Sample mobile apps for common scenarios Sample mobile apps for common scenarios appsheet.com

(KOIN BUSYNESS) #13

@Levent_KULACOGLU

https://bit.ly/2KrCmJr

or

https://bit.ly/2KqpZh0