Rangsum with filter in Year

[JMAROUF]

Hi everyone,

i have an issue with rangesum function, there is the formula:

=sum(aggr(rangesum(below( SUM(total { <Year=>} distinct NB_CORES),0,NoOfRows())),Year) )

it was working before adding an if in the filter dimension (without any filter), the business requires that only years  between 2010 and 2020 should be showed in the filter, then i have used a master dimension using :

if(Year >= $(vStart) AND Year <= $(vEnd) , Year)

after that my formula didn't work, can anyone help please.

Regards; 

[JMAROUF · Accepted solution]

The Only solution i found is to create a dimension within the model with this condition  if(Year >= $(vStart) AND Year <= $(vEnd) , Year)  as Exercice, and  then  used it in the formula:

=sum(aggr(rangesum(below( SUM(total { <Exercice={">=$(vStart)"}>} distinct NB_CORES),0,NoOfRows())),Exercice) )