need to avg a field even though there is nothing selected

[#1]

Hi,

I have a chart and I need to show REGION values if there is nothing selected in PAIS listbox

and then if there is a selection need to show the selected field values.

I´m using this, but doesnt work.

if(PAIS <> '' , avg({$<PAIS ={[REGION]} , PRODUCTO = {[wwww]}>} MS%), avg({$<PRODUCTO = {[wwww]}>} MS%))

Any ideas?

Thanks

Adrian

[sunny_talwar · Accepted solution]

Try this:

If(GetSelectedCount(PAIS) = 0, Avg({<PAIS = {'REGION'}, PRODUCTO = {'wwww'}>} MS%), Avg({<PRODUCTO = {'wwww'}>} MS%))

[#3]

Thank you so much!!