Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, I want to calculate the average of a column with a filter on 3 other columns
A,B,C,D are the columns
Average of A
When
B = True
C = True
D = True
Hi @pittouti
B, C, D contains true value?? if so, try like below
Avg({<B={'True'},C={'True'},D={'True'}>}A)
else, replace the true value with some other values.
Hope it helps