Sum of the value from virtual column

[Celes]

hi,

Please help. I need to get the sum of the value from my virtual column but it returns the sum of all virtual column in my app : for example

ColumnName virtual column 1 i have 2, 3, 4 sum should be = 9

ColumnName virtual column 2 i have 4,5,6 sum should be = 15 but it returns 24 (because 9+15)

ColumnName virtual column 3 i have 7,8,9 sum should be = 24, but it returns the sum of all value from all the column which is 48.

this is my formula for sum column Sum([ColumnName ])

Any suggestion to improve my formula please

[LeventK]

@Celes
Try with this:

SUM(
    SELECT(
        Tablename[VirtualColumnName],
        [KeyColumnName] = [_THISROW].[KeyColumnName]
    )
)

[Celes]

SUM(
SELECT(
Tablename[VirtualColumnName] - is it the “RELATED column name” or the specific column name which is the place holder of the number? ,
[KeyColumnName] = [_THISROW].[KeyColumnName]
)
)

[LeventK]

@Celes
Are those virtual columns contain REF_ROWS() expression? I mean are they related records??

[Celes]

yes it contain REF_ROWS() expression

[LeventK]

Which column you want to sum up from the child table? What’s the column name?

[Celes]

Column name is Hold Duration

[LeventK · Accepted solution]

SUM([VirtualColumnName][Hold Duration])

[Celes]

thank you @LeventK, it works!

I’m hoping for your reply from my 1st inquiry. the complex expression Lookup expression

[LeventK]

@Celes I will look into it when I have some time. A bit busy these days. Please share the gSheet of the app with edit access as well, so that I can check.

[Celes]

thanks @LeventK, shared already