Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if($(vShowCountPercent) = 'x', (count(distinct if(len(answer) > 0, id))))
I can't seem to understand the problem here. I get "Error in Expression" error on this one. I am trying to include this to enable conditioning for my measures. Thank you
You have a variable in your expression, what's hidden behind it?
Maybe you should add a = sign in your dollar expansion like this :
=if('$(=vShowCountPercent)' = 'x', (count(distinct if(len(answer) > 0, id))))
Thanks for the quick response. That works like a charm.