2 Replies Latest reply: Mar 14, 2013 9:08 AM by Kaushik Solanki

Use Variable in Expression

Lance James Mar 14, 2013 9:03 AM

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

Re: Use Variable in Expression

Celambarasan Adhimulam Mar 14, 2013 9:08 AM (in response to Lance James)

Set a variable as
vBudget = 2013 BUDGETV2
Expression
Sum({<BUDGETID={'$(vBudget)'}>} BUDGETAMT)*-1
Like Show 0 Likes (0)

Actions
Re: Use Variable in Expression

Kaushik Solanki Mar 14, 2013 9:08 AM (in response to Lance James)

Hello,

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

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

Regards,
Kaushik Solanki
Like Show 0 Likes (0)

Actions