Set Analysis in not working in sense

[zain16nib]

//Sum({<TAG={DEP} >}Balance) WORKING

//Sum({<TAG={DEP}, Ndate={42735} >}Balance) WORKING

variable is not working

Sum({<TAG={DEP}, Ndate={$(Var_Cur_Date)} >}Balance)

variable expression

Max(Cur_Date)

Kindly guide

Zain.

[shraddha_g · Accepted solution]

try

Variable Expression as

=Max(Cur_Date)

and then use

Sum({<TAG={DEP}, Ndate={'$(Var_Cur_Date)'} >}Balance)