Exclude Selections

[rido1421]

Hi There

I have a field [CurrentFiscalMonth]

the value for this field is the current fiscal month so right now it is 5

I would like to use this value and keep it constant regardless of any selections made

When selecting future months this value becomes in valid which is correct.

I would just like to get a function to keep it regardless of any selections

eg. Sum({1<FiscalMOnth={5}>}Forecast)

I want to do this but without the Sum...

if there anything like below... that i could use in an expression.

eg  1< {[CurrentFiscalMonth]}>

Thanks.

[rubenmarin]

Hi Rido, there is an Only() function:

Only({1<FiscalMOnth={5}>}Forecast)

[rido1421]

Hi Ruben

It doesnt seem to be working

vCurrentFiscalMonth= Max(CfiscalMonth)

Only({1<CfiscalMonth={$(vCurrentFiscalMonth)}>}CfiscalMonth)

IT still changes when selecting a future month

[rubenmarin · Accepted solution]

Hi Rido, you're filtering CfiscalMonth with the value of vCurrentFiscalMonth.

If you want vCurrentFiscalMonth to store alwallys the max CfiscalMonth you can use:

vCurrentFiscalMonth= Max({1} CfiscalMonth)

[rido1421]

Thanks Ruben that works