Variable not filter in set analyses formula

[lomi89]

Hi Team,

I created a formula in set analisys with 3 variables:

sum({<CLAIMS=P({<date={'$(vAgrupos)'},flag_modulo={'$(vModulo)'},COST= {">=$(=vCoste)"} >}NO_SINISTRE ) >} COST)

I would like to know if you have some idea for filter o not filter. I mean, in this formula this variables always filter the table but I want to depend on the user filter the table or not.

For example, flag_modulo is 1 or 0. I would like to put in the button where the user inputs the variable: 1, 0 or all (not filters).

I hope I explained me.

Thank you very much.

[joaopaulo_delco]

Hi @lomi89 !

     Try this way:

sum({<CLAIMS=P({<date={"$(vAgrupos)"},flag_modulo={"$(vModulo)"},COST= {">=$(=vCoste)"} >}NO_SINISTRE ) >} COST)

[lomi89]

Sorry, it doesn't work. It's  the same like my formula