Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
If(GetSelectedCount(PAIS) = 0, Avg({<PAIS = {'REGION'}, PRODUCTO = {'wwww'}>} MS%), Avg({<PRODUCTO = {'wwww'}>} MS%))
Try this:
If(GetSelectedCount(PAIS) = 0, Avg({<PAIS = {'REGION'}, PRODUCTO = {'wwww'}>} MS%), Avg({<PRODUCTO = {'wwww'}>} MS%))
Thank you so much!!