Set Analysis

[srinivasa1]

Hi 

I know I’m making mistake in SetAnalysis not able to figure out how to achieve this

I need to change font color of text object dynamically  based on List box CalcValue selection ie: if selected 7 from calcValue list box its falls under (Low Value 1 and HighValue 10) in that case need to set textObject calculated font color as RGB(255,0,0) same way if calc value changes color code must change based on low and high val color.

below is script and i have attached dummy application

=MaxString({$<ID={'$(=$(v_ID))'},Key={'$(=$(v_Key))'}, type={$(v_Type)}, LowVal={"<=$(v_calcVal)"}, HighVal={">=$(v_calcVal)"}Color)

Highly appreciate help on this

[srinivasa1]

Hi

Is any guidence?

Thanks

[MayilVahanan]

Hi

Try like this

=MaxString({$<ID={'$(=$(v_ID))'}, type={'$(=$(v_Type))'}, LowVal={"<=$(=$(v_calcVal))"}, HighVal={">=$(=$(v_calcVal))"}>}Color)

Have doubt, calcValue is not link with any field just using for calculation purpose, then why you can't use input box instead of list box?

v_key is always specific women only?

[srinivasa1]

Thanks For your replay.

your right calcValue is not link with any field just using for calculation purpose.i need use like this only

v_key is always specific not women it also foe man based on add type form button

still my font color not get change i need use setanalysis as caluclated color

Thanks

[giakoum]

Please see attached.

Changes :

1. Variables needed = sign

2. Set analysis had wrong syntax

3. 3 new columns in excel for R, G, B

4. By using GetSelections you need to select something in those fields in order to get a result