Using Col Sum to return certain value for all row
I want to creat a new colum ":Resuts Test 1" that will return the sum of all value in the :Results column that has a corresponding 1 in the :Test column. Im using the formula col sum(:Results,:Test) and the above image is what I"m getting. What i want is to have the sum of result for test 1 to be across all the rows, as shown in the below picture.
Re: Using Col Sum to return certain value for all rowThis column formula will do what you want.
test1rows = Current Data Table() << Get Rows Where( :Test == 1 );
Sum( :Results[test1rows] );
**I just saw Jim's solution and it is better
Re: Using Col Sum to return certain value for all rowThis should work:
col sum(If(:Test == 1, :Results, . ) );
Re: Using Col Sum to return certain value for all rowHow about you right click on one of the cells with the value you like and select Fill -> Fill to end of table
