Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Set a variable as
vBudget = 2013 BUDGETV2
Expression
Sum({<BUDGETID={'$(vBudget)'}>} BUDGETAMT)*-1
Set a variable as
vBudget = 2013 BUDGETV2
Expression
Sum({<BUDGETID={'$(vBudget)'}>} BUDGETAMT)*-1
Hello,
Consider your variable name is vVariable then your expression will become like below.
Sum({<BUDGETID = {"$(vVariable)"}>}BUDGETAMT)*-1
Regards,
Kaushik Solanki