How to use variables in expressions

[#1]

I have this expression in pivot table:

sum( {$<AcNo= {'>=3000<=3999'},VoDt= {'>20130101<20130328'}>} AcAm)

I like to use variables from_date and to_date (ihave created) instead of 20130101 and 20130328. How to do that?

//Gunnar

[Gysbert_Wassenaar · Accepted solution]

Use dollar-expansion. This looks like $(vMyVariable) for a variable name vMyVariable

sum( {$<AcNo= {'>=3000<=3999'},VoDt= {'>$(from_date)<$(to_date)'}>} AcAm)

[fdelacal]

sum ( {$<AcNo= {'>=3000<=3999'},VoDt= {"$(='>='& MonthStart(date(vHOY),-2)&'<='&MonthEnd(date(vHOY),0)"}>}AcAm)

vHOY = DATE(TODAY())

Hope it helps you.

Regards.

[#4]

hi

try this

sum( {$<AcNo= {'>=3000<=3999'},VoDt= {'> $(from_date) < $( to_date )'}>} AcAm)

[#5]

What do $ sign mean in the syntax?

//Gunnar