Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can we write set analysis expression for showing Avg(Population) for dates less than X.
For example, if I have population value at 3 different dates (W, X, Z), I would like to show Avg(Population) for all the dates less than X. Average value should not include population value at Z.
Hi,
Let vDate=Max(x);
avg({<Date={'=<($(vDate))'}>} Population)