Dynamic Aggregation

[#1]

Hey guys:

based on user input I want to compute an average over a specific field:

Set vMenu = GetFieldSelections([Menu Item]); (will return Sales or Revenue or Profit..... and so on)

expression: =avg($(vMenu))

For some reason this does not work, even while $(vMenu) will return Sales

and avg(Sales) will also return a valid number.

Any ideas what might be happening?

[MK_QSL]

Try

expression: =avg($(=vMenu))

[#3]

Nope, unfortunately

[tresesco]

Could you post your sample app with the issue?

[#5]

Yes, here is a demo app with public data.

[tresesco · Accepted solution]

Put '=' in variable definition. See attached.

[#7]

Try =avg($(=$(vMenu)))

[#8]

Try =avg($(=$(vMenu)))

I tested with selecting Sloop. it works. for other fields Menu list does not have corresponding same name in the fields..

[#9]

Thanks, I had tried with '=', but I must have made some typo. Anyway, now it works:

set vMenu = ='[' & GetFieldSelections([Menu Item]) & ']';

[tresesco]

Yes, that would be required for values with spaces in between.