Using a String Variable with Set Expressions

[#1]

Hi Folks:

CAn't get this to work.  Result is always nothing.

Set Varx ="ACME INC";

=If (Count ( {$<[Install Site GU Company Name]={'$(Varx)'}>} [Serial Number])>0, Count ( {$<[Install Site GU Company Name]={'$(Varx)'}>} [Serial Number]))

Thanks.

[jagan]

Hi,

This expression is working, seems it is similar to yours.

Set Varx = 'a';

Expression = Sum({<[Student id]={'$(Varx)'}>} Mark1)

What are the dimensions you are using?  Can you attach sample file?

PFA, hope it helps you.

Regards,

Jagan.