How to get Col Sum of a row in a conditional statement?
Hi all, I have a column where I need to filter out some values to get the sum of columns (using Col Sum). Is it possible to get the col sum according to the condition? For example, every 0 code will be excluded from the computation: CodeQtyTotal CountTotal % (Col Sum (qty)/total count)050250-025250-160250205/250 x 100 = 82%667250205/250 x 100 = 82%378250205/250 x 100 = 82% I tried using an If stat...