Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 .
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 .
Can you try this:
=Avg({$<date = {"$(=Min(date))"}>} value)
or
=Avg({$<date = {"$(=Date(Min(date), 'DateFieldFormatHere'))"}>} value)