Set analysis for projects with sales over 0

[enfodavid]

Is it possible to make a set analysis checking for sales of a project that exceed zero with a variable?

Sum({<Project = {"$('vProject')"}>}Sales)

Where the variable vProject is set to 'Sales > 0' but can be switched for 'Sales <=0' e.g.

Or am I going about this all wrong? I'm using a variable to be able to switch this out all through the app with a simple change of a variable (read "press of a button")

Thanks in advance

[Chanty4u]

try this

Sum({<Project = {"=$(=vProject)"}>}Sales)

[enfodavid]

Doesn't seem to work, maybe the variable should be more than just 'Sales > 0' ?

[Chanty4u · Accepted solution]

may b

Sum({<Project = {"=sum(sales)>0"}>}Sales)

[enfodavid]

Yes, that works so it must be me using a variable like a tool :^)

[Chanty4u]

Cool