Using expression in set expression

[#1]

Hi all,

I haven't done lot of set analysis recently and I just got a problem.

I trying to get the average of a value on the first date of my set analysis.

I am using the following expression :

= avg( {$<date = {$(=Min(date))}>} value )

But I got an empty result.

Can any of you see what I am doing wrong ?

Thanks in advance.

[#2 · Accepted solution]

Hi again,

I knew it was easy I was just going a bit nuts on the $ sign syntax.

So the answer to this :

avg({$<date={"$(=min(date))"}>} value)

If anyone ever have the same problem remember that the official documentation is confusing. I found the correct syntax here .

[sunny_talwar]

Can you try this:

=Avg({$<date = {"$(=Min(date))"}>} value)

or

=Avg({$<date = {"$(=Date(Min(date), 'DateFieldFormatHere'))"}>} value)