set anaylysis

[srinivasa1]

Hi

can any one guide me how i can  add variable =   num($(vCalc)*100,'#.#') in below set analysis need to replace val1 and val2  with variable..

=MaxString({$<Id={'E01'},Key={'$(=$(vKey))'}, Type={$(vType)}, Val1={"<=7.1"}, val2{">=7.1"}>}id)

Thanks

[#2]

can u post the value(expression) of vCalc ?

[#3]

Hi,

try like this

=

MaxString({$<Id={'E01'},Key={'$(=$(vKey))'}, Type={$(vType), Val1={>=${=<$(Var)}}>}id)

[srinivasa1]

Hi thanks for quick response.

it will be 7.1 .

but i need add >=vCalc and >= vCal

Thanks

[srinivasa1]

Thanks for reply its shows some script error.

[#6]

MaxString({$<Id={'E01'},Key={'$(=$(vKey))'}, Type={$(vType), Val1={>${=<$(Var)}}>}id)

still if it is not working post your app with sample data

[srinivasa1]

Hi

Thanks for replay i have attached file.pls dont worry about data.just i need change font color based on val1 and val2..for Value

thanks in advance

[srinivasa1]

hi

Any guidence.

[srinivasa1]

hi

chanred2 did you got my attached file.

[#10]

Hi,

I have got somewhat. check the attached file.. i didn't use setanalysis but i implement through if statement.. if you want to see the formula the

go to expressiontab--> expandexpression there you can find textcolour..

regards,

Chandra