Driving a text box action based on the expression value of the textbox

[#1]

Hello,

          I have a dashboard which has text boxes, the textbox values are expression which would result in a numeric value and there is an action of navigating to a new sheet set on each text box. I want to perform this action only when the textbox value is > 0. How can I acheive this?

r/U

[alexandros17]

if the sheet ID you want to select is SH02 and the field to test is "valore' then

the trigger select sheet in the button is:

=if(valore>0, 'SH02','')

[#3]

Thanks for you reply Alexander. The same does not work for Select in Field Action i.e for both the Field and Search String.

Ex:  If Code is a field and if Variable v_OpenIncidents>0 then I need to select 'TXT' from the Code field. This is what I have given.

Field:   =if($(v_OpenIncidents)>0,code)

SearchString:   =if($(v_OpenIncidents)>0,'TXT')