Variables in expression

[#1]

Hi All,

I'm going to use variable for my Field values.

count({<P_Name='Z_Territory'}>}DISTINCT PRIOR_DATA) this expression works fine. I want to use Variable for the values like 'Z_Territory'.

count({<P_Name="vZTerritory"}>}DISTINCT PRIOR_DATA) but this is not giving correct result.I'm doing some silly mistake here.???

[fkeuroglian]

Hi,

The only thing you have to do is change the expresion , and of course create the variable

exmple:

count({<P_Name=$(VARIABLE)}>}DISTINCT PRIOR_DATA) this expression works fine. I want to use Variable for the values like 'Z_Territory'.

if you want to obtain the value of the variable you have to put in $(variable), not " "

good luck

Fernando

[#3]

Never mind.Got it.

count({<P_Name={$(vZTerritory)}>}DISTINCT PRIOR_DATA)