topic Re: Using expression in set expression in App Development

Using expression in set expression

Thu, 18 Aug 2016 02:49:16 GMT

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.

Thu, 18 Aug 2016 04:00:57 GMT

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 — Thu, 18 Aug 2016 08:22:09 GMT

Can you try this:

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

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