Field event trigger not working with getactivesheetID

[#1]

I have a field on which I am trying to apply Active Sheet Trigger.

To get currently active SheetID , i use the following syntax

vActiveSheetID=  chr(39)& right(getactivesheetid(),4)& chr(39) = 'SH01'

In field event trigger, I use the variable vActiveSheetID and it does not recognize the variable I have created.

But, when I hardcode the value 'SH01'. The trigger works just fine

Trigger Syntax: IF(getSelectedCount(InvoiceDate)='1','SH01','SH02') works fine

Variable Reference Sytanx =  IF(getSelectedCount(InvoiceDate)='1',vActiveSheetID,'SH02')

Can someone direct me what I am not doing correctly?

Much appreciate your time

Thank you

[disqr_rm]

Try

Variable Reference Sytanx =  IF(getSelectedCount(InvoiceDate)='1',$(vActiveSheetID),'SH02')

[#3]

That did not help either

[disqr_rm]

Post a sample qvw here.

[#5]

Hi

Try to loose the chr(39) in your variable. The variable itself will be a string, and therefor you do not need them in your expression.