Aggragating variable in set analysis

[#1]

Hello all,

I'm simply trying to use a variable (vCommissionableTotalSales) in my set analysis like this:

Sum({$<Month={'=Month(today())'}>} $(vCommissionableTotalSales))

...which gives me an error: Nested aggregation not allowed. Is this not possible to do?

[MK_QSL]

What is the definition of vCommissionableTotalSales?

[#3]

Where are you using this expression?

[#4]

vCommissionableTotals = Sum({$*BM13} [Sales Amount])

[MK_QSL]

Remove SUM

Only({$*BM13} [Sales Amount])

and try

[#6]

Not sure if you meant "{$*BM13} [Sales Amount]" or "Only({$*BM13} [Sales Amount])", but I tried both as the variable definition. The first gave an error and the second returned null.

[MK_QSL]

My Mistake,,,, Only will not work here... will check and come back to you on this

[#8]

I'm actually trying to use this in a text box. In the full expression I'm adding "=" to the beginning.

[#9]

I ended up just adding to my set analysis the criteria used in the variable's set analysis like so:

Sum({$*BM13<Month={$(=Month(Today()))}>}[Sales Amount])

Worked just fine. Just thought it'd be easier to use the variable.