Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I need a set analysis statemet which selects all available months within a Fiscal Year until the selected months and builds the sum of a value.
Regards and thanks
See
Can you share a sample?
So you have a Fiscal Year and a single Month selected?
Then try something like
=Sum({<MonthField = {"<=$(=Max(MonthField))"}>} Value)
MonthField should have a numeric representation, like Month() QV function is generating a dual value by default.