Set Analysis expression error

[Peony]

Hi all

I created set analysts formula =Avg({<Period_FK = Num(Today())>} Duration).

But for some reason I get an error message: "Error in set modifier element function name: "}" expected ". And I can't get where should I put these "}"?

[agigliotti · Accepted solution]

maybe this:

=Avg( {< Period_FK = {"=Num(Today())"} >} Duration )

i hope it helps.

[Peony]

Great! It works! Thank you!