Need to find total value from ref table using SUM()

[Badminton_Scori]

Hi ,

I am trying to calculate the total value of the ref table by using the below formula

SUM(SELECT(Bills[Line value],AND([Customer Name]=[ID],[Status]=“Credit”)))

I am using the above formula in the parent table in virtual column but I am not getting the total value .

I need to total value ,where the status is credit ,Please help me with the expression

[Koichi_Tsuji]

Badminton_Scoring:

SUM(SELECT(Bills[Line value],AND([Customer Name]=[ID],[Status]=“Credit”)))

SUM(SELECT(Bills[Line value],AND([Customer Name]=[_thisrow].[ID],[Status]=“Credit”)))

Probably you are missing [_thisrow]. operator.

[Badminton_Scori]

Hi ,

I tried with the above expression but I could not able to get the total ,it remains 0

[SkrOYC]

Since that’s an inline view, a virtual column called something like [Related BLABLA]
You can do this by:

SUM(
  [Related whatever][Line value]
)

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

[Koichi_Tsuji]

SkrOYC:

SUM(
  [Related whatever][Line value]
)

Try that one , not my one.

[Badminton_Scori]

Hi ,

I tired ,its sum all the row values ,I need to add the value ,where the status column is equal to Credit

[Koichi_Tsuji · Accepted solution]

SUM(Select([Related whatever][Line value],[Status]=“Credit”))

[Badminton_Scori]

Thanks @tsuji_koichi is working fine