How To add Variables in such Expression?

[sspawar88]

Set VgreenMin=-1;

Set VgreenMax=-10;

Count({$<param_name={'TEMP'},param_value={'<=-1>=-10'}>}param_value)/

Count(total <Month,DayN,WeekNumber>{<param_name={'TEMP'},param_value={'<=-1'}>}param_value)

and 

i'm trying like that

Count({$<param_name={'TEMP'},param_value={'<=$(VgreenMin)>=$(VgreenMax)'}>}param_value)/

Count(total <Month,DayN,WeekNumber>{<param_name={'TEMP'},param_value={'<=-1'}>}param_value)

what need to be change in way of using Variables?

Thanks In advance.

[avinashelite · Accepted solution]

change the single quotes to double and check, when your using the variable inside the value its should be double quotes

Count({$<param_name={'TEMP'},param_value={"<=$(VgreenMin)>=$(VgreenMax)"}>}param_value)/

Count(total <Month,DayN,WeekNumber>{<param_name={'TEMP'},param_value={'<=-1'}>}param_value)

[sunny_talwar]

You can also try this:

Count({$<param_name={'TEMP'},param_value={"$(='<=' & $(VgreenMin) & '>=' & $(VgreenMax))"}>}param_value)/

Count(total <Month,DayN,WeekNumber>{<param_name={'TEMP'},param_value={'<=-1'}>}param_value)

[#4]

Hi

param_value={">=$(=VgreenMin)<=$(=VgreenMax)"} >}

use above expreesion hope it will work

Thanks

Manju

[sspawar88]

Thanks Sunny

[sspawar88]

Thank u so much Manjunath

[maxgro]

I think (as Avinash suggested) your expression is correct, you can change quote with double quote in search string (but also quote should work)

a small test

sum({$ <exp={"<=$(VgreenMin)>=$(VgreenMax)"}>} exp)