Use Variable in Expression

[#1]

I want to use a variable to replace "2013 BUDGETV2" in the below expression, what is the correct formula for this?

Sum({<BUDGETID={[2013 BUDGETV2]}>} BUDGETAMT)*-1

THANKS in advance

[CELAMBARASAN · Accepted solution]

Set a variable as

vBudget = 2013 BUDGETV2

Expression

Sum({<BUDGETID={'$(vBudget)'}>} BUDGETAMT)*-1

[kaushiknsolanki]

Hello,

     Consider your variable name is vVariable then your expression will become like below.

     Sum({<BUDGETID = {"$(vVariable)"}>}BUDGETAMT)*-1

Regards,

Kaushik Solanki