AVG() Function with many conditions

[pittouti]

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

[MayilVahanan]

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