Is it possible to sum corresponding values from an EnumList in a table such as below?
In a virtual column you can use below expression: SUM(SELECT(Tablename[COST],[CATEGORY]=[_THISROW].[CATEGORY]))
@Levent_KULACOGLU This is the error message I get:
Cannot compare Text with List in ([CATEGORY] = [Vkey].[CATEGORY])
I tried it, but I still have some challenges with the summation. Kindly assist. with the expression
@KOIN_BUSYNESS can you add levent@able3ventures.com as a co-author to your app so that I can check? Thnx.
@KOIN_BUSYNESS may I ask what is [Vkey]?
@Levent_KULACOGLU Vkey is the primary key in that table
@KOIN_BUSYNESS whatโs the column type for [Category]?
LIST Itโs a list of food Categories
Try this:
SUM(SELECT(TableName[COST], IN([_THISROW].[CATEGORY], TableName[CATEGORY])))
Thank you, will feedback soon
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
Can you share the farmsales app so i can see how you coded it?
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |