topic AVG() Function with many conditions in App Development

AVG() Function with many conditions

pittouti — Mon, 14 Dec 2020 17:26:05 GMT

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 — Tue, 15 Dec 2020 00:49:20 GMT

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