Hi everyone,
I'm trying to use the cumulate
function to sum only the FY26 months of the metric Nexus Lowest Level, but the output includes all years instead of just FY26.
Has anyone run into this or knows how to fix it?
Thanks in advance!

Hi everyone,
I'm trying to use the cumulate
function to sum only the FY26 months of the metric Nexus Lowest Level, but the output includes all years instead of just FY26.
Has anyone run into this or knows how to fix it?
Thanks in advance!
Hi,
CUMULATE() with the filter works as expected.
But then by adding nBY: Month.Year] modifier you actually replace Month with Year - you can see that the total for FY24 is repeated for each month.
Please pay attention to the orange indicator on the left.
If you open the metric with the BY modifier in Formula Playgroud and chose automatic structure, you will see that this metric have Year dimension, not Month.
Hope it helps.
Yuri
Hi Yuri! Thanks for your response!
I did not quite understand what’s the final solution tho. My formula is dimensionalized by year already. What should I do to just sum FY26 and not all years in the cumulate formula?
Hey
In this case, you don’t need to use CUMULATE.
You could do the following
'Nexus Lowest Level IS'lBY SUM:MONTH.YEAR]YSELECT:YEAR."FY 26"]
Here is a detailed explanation of this formula :
Hope this helps,
Thank you! It works.
Appreciate your help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.