Variables bug with Expression editor?

[#1]

I defined a small number of variables based on table values in a script so that I could refer to the variable, rather than directly to the table value using an inter-record function in a chart formula. This worked fine in a small application. 

However, when I scaled it up to an app with a lot more data, but similar structure, it appears to cause problems.  In particular, the expression editor shows "Expression OK", but the expression produces null values.  Furthermore, if you type random stuff at the end of the expression, the expression editor continues to show "Expression OK", instead of "Garbage after ')'...", as one might expect it to do.

Any suggestions?

Thanks!

[#2]

I'm afraid not!  It works on the small version, but not with the larger one, as with the construction using Only().

[Roop]

It must be the value of T1.

I would create a small text box on each application with the content "=T1" and see if they are different.....

Are you sure that the variable exists in the larger one .... ?

[#4]

Both of those work fine.

[Roop]

Can you cut down an example and post to the site .... ?

You probably have some confidential data (which obviously should not be posted), but can you post without?

Thanks

[Roop]

Just a quick thought ..... Does the Tariff that is in T1 actually exist in both applications?

[#7]

Yes, I am reading it from an input table.

I can post the small app - it has made-up data.  I'll see if I can figure out a way of posting a cut-down version of the larger one.

Thanks!

[Roop]

Thanks

[Peter_Cammaert]

Just nitpicking: the initial expression uses T1, but your description about the larger application talks about Ta1?

A typing error, or is it that something small has changed between reloads?

[#10]

I changed the name to Ta1 in the big version in the vain hope that the

problem might be a conflict with some system variable, or something of that

kind. I didn't mention it previously to reduce confusion! I refer to T1

in the small version and Ta1 in the big version.

[#11]

I should have said, the table that uses the expression with reference to the variable T1 is the one entitled "Table: by user".

Sorry for any confusion!