Help in Aggr() with Variable as a parameter

[aniketsr]

Hi,

Iam passing a variable in Aggr() function as parameter,but the value that i get is Zero.

Iam also attaching a sample QVW.

[mayankraoka]

Hi Aniket,

Just put = to your variable(vValueSelected) where it is defined(CTRL+ALT+V).

Regards,

Mayank

[aniketsr]

I did it but did not work

[mayankraoka · Accepted solution]

Hi Aniket,

Attached update app.I am able to fetch the value.

Regards,

Mayank !

[Kushal_Chawda]

try with single quotes

'$(vValueSelected)'

[suryaa30]

Hi Please use below expression.

num(Sum(Aggr(RangeSum(Above(TOTALsum(Expense)/1000,0,12)),$(=$(vValueSelected)))))