Problems with set analysis

[uridiumabs]

Hello,

I need to show a column in a Pivot Table wich counts some rows depending on a condition:

the formula is:  Count(Distinct  {$<[$(variable1)+$(variable2)]= {'>0'}>} [CommercialSite])

So I want to count comercial sites that variable1 greater than 0 and variable2 greater than 0. This sentence is not working because is counting all rows as if no condition is set.

I have checked the syntax and for me is ok, Can anybody help me with this?

Thank you very much.

[uridiumabs]

I'm sorry Matus, I don't get you.

Could you please attach the screenshot?

Thank you very much

[mkelemen]

@ has no special meaning here I just used it so that the variable is visible - otherwise the $(variable) would be replaced by the value inside.

[eduardo_dimperio]

Understood, thank you Matus