nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using Col Sum to return certain value for all row

JustinN

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.

Capture 2.JPG

Accepted answers

txnelson

This should work:

col sum(If(:Test == 1, :Results, . ) );

All comments

pauldeen

How about you right click on one of the cells with the value you like and select Fill -> Fill to end of table

txnelson

This should work:

col sum(If(:Test == 1, :Results, . ) );

cwillden

This 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