Modify expression

[Anonymous]

Hi,

Please help me to modify expression avg({1} MyField)

I want to show avg of all, but manage by Filter MYear.

In my case if I select any month in MYear, it shows trend for all month.

Thanks,

[#2]

did you try creating a bookmark (Clear Other Fields - MYear)

and changing your expression to :  avg( {MyBookMark} MyField)  ?

[Anonymous]

Thanks for reply,

Bookmark doesn't work when you publish it.

Cheers,

[#4]

did you try combine getfieldselection() ?

something like 

avg({1<MYear={getfieldselections(MYear)}>} MyField)

[Anonymous]

Something's wrong.

avg({1<MYear={getfieldselections(MYear)}>} MyField)

getfieldselections(MYear)}>}  ----it doesn't reconise command.

[#6]

it was only an idea

but i'll try to write it myself

[Anonymous]

I tried like it

avg(TOTAL<MYear> MyField).

It doesn't work with Filter

[#8]

if you select always one year this should work

sum({1<MYear={'$(=GetFieldSelections(MYear))'}>}MyField)

does this satisfy you?

[#9]

=sum({1<MYear={$(=GetFieldSelections(MYear,','))}>}MyField)

//i just remove ' sign

[Anonymous]

It doesn't work.

I just copied your expression and fixed MyField.