Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
please consider below table:
i want to sum all the row number but the numbers that mention in refer to column
row | number | refer to |
1 | 500 | |
2 | 400 | 1 |
3 | 100 | 1 |
4 | 20 | 3 |
5 | 40 | |
6 | 30 |
result = 400+20+40+30=490
explain :there are 2 unique numbers in refer to column ( 1 and 3) it means sum all the row number but 1 and 3
Hi @entsh
Try like below
Sum({<row ={$(vreferto)}>}number)
vreferto =Concat(DISTINCT If(Len(Trim([refer to]))>0, [refer to]), ',')
O/p:
Hi @entsh
Try like below
Sum({<row ={$(vreferto)}>}number)
vreferto =Concat(DISTINCT If(Len(Trim([refer to]))>0, [refer to]), ',')
O/p: