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
Solved! Go to Solution.
SUM(Select([Related whatever][Line value],[Status]=“Credit”))
SUM(SELECT(Bills[Line value],AND([Customer Name]=[_thisrow].[ID],[Status]=“Credit”)))
Probably you are missing [_thisrow]. operator.
Hi ,
I tried with the above expression but I could not able to get the total ,it remains 0
Since that’s an inline view, a virtual column called something like [Related BLABLA]
You can do this by:
SUM(
[Related whatever][Line value]
)
Try that one , not my one.
Hi ,
I tired ,its sum all the row values ,I need to add the value ,where the status column is equal to Credit
SUM(Select([Related whatever][Line value],[Status]=“Credit”))
Thanks @tsuji_koichi is working fine
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |