Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i want to set a variable in the script that have-
if($(v_metric_5)<90,'red',if($(v_metric_5)<95,'yellow',if($(v_metric_5)<=100,'green','gray')))
how can i do that?
Please do not cross-post (post the exact same question multiple times) as it is counter-productive. Read the Community guidelines and do your best to follow them
Hi adi, one way is using an alternative character for simple quotes and dollars, and use replace to reset to original characters, ie. using | as simple quote and # as dollar:
LET VarName =Replace(Replace(
'if(#(v_metric_5)<90,|red|,if(#(v_metric_5)<95,|yellow|,if(#(v_metric_5)<=100,|green|,|gray|)))'
,'|',Chr(39)), '#', '$');
try this
=IF(v_metric_5<00,Red(),IF(v_metric_5<9510,Green(),IF(v_metric_5<=100,Blue())))