How to use variables in expression sets

[Anonymous]

Hi Everyone,

I'm trying to use an expression that filters my results depending on a variable. I have a variable v_Previous_Date which has the previous date found in the max value from the Date field (max(Date))

I need to make work an expression like this:

sum({$<Date=$(v_Previous_Date)>} Amount)

It doesn't work. Does anyone can help me?

[Miguel_Angel_Baeyens · Accepted solution]

Hi Jose,

Try the following instead:

Sum({< Date = {'$(=Date(v_Previous_Date))'} >} Amount)

Hope that helps.

Miguel

[MayilVahanan]

hi,

     Try this,

          = Sum({<Date = {'=$(=v_Previous_Date)'}>}Amount)

     Hope it helps

[Anonymous]

It works, thanks everyone!

[rwunderlich]

You'll need braces around the value.

sum({$<Date={$(v_Previous_Date)}>} Amount)

Since you stored max(Date) in a variable, it's a string so probably in mm/dd/yyyy format. You may need single quotes around the value as well.

sum({$<Date={'$(v_Previous_Date)'}>} Amount)

-Rob