Variable

[upaliwije]

I have following Pivot Table

Column 1 has the following expression

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =,RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT)

Column2 has the following expression

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =>}$(vTsale))

My variable 

 $( vTsale)=sum({<RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT)

My Column 2 does not show any value. Can you please help me to correct my Column 2  Expression

[edwin]

try this:

sum({$<PERIODID = {$(=Max(PERIODID))},RC_R_TYPE={'DIRECT','FT'},YEAR =,QUARTER =,MONTH =,PERIOD =>}RC_AMOUNT)

[edwin]

the problem is, depending on how the variable is defined it could be doing this:

sum({$<PERIODID = {$(=Max(PERIODID))},YEAR =,QUARTER =,MONTH =,PERIOD =>}sum({<RC_R_TYPE={'DIRECT','FT'}>}RC_AMOUNT))

which will not make sense to QV

[edwin]

now looking at your screenshot (bec its hard to read bec its very small and smudged) that may be what is being resolved as