Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question concerning the creation of a new field in Sense.
I have created a master-item in which I compare a ratio value (numerator/denominator) to a 4-steps range (different for each ratio) and based on this comparison I assign a string value of High, Medium-high, Medium-low and Low to each of them. Now I would like to have this new list of string-values as a field inside my script. How can I create a field value based on this master-item?
for example:
ratio high medium-high medium-low low indicator
0.2 1 0.6 0.4 0.1 low
0.5 1 0.8 0.4 0.05 medium-high
0.9 0 0.4 0.8 1 low
Just for being clear I have used a multiple if statement in my formula:
IF([scale type]='direct',
(IF((ratio) >= 0 and (ratio) <= ("low"), 'low',
IF((ratio) > ("low") and (ratio) <= ("medium-low"), 'medium-low',
IF((ratio) > ("medium-low") and (ratio) <= ("medium-high"), 'medium-high',
IF((ratio) > ("medium-high") and (ratio) <= ("high"),'high'))))),
(IF((ratio) >= 0 and (ratio) <= ("high"), 'high',
IF((ratio) > ("high") and (ratio) <= ("medium-high"), 'medium-high',
IF((ratio) > ("medium-high") and (ratio) <= ("medium-low"), 'medium-low',
IF((ratio) > ("medium-low") and (ratio) <= ("low"),'low))))))
Hi,
Just try like below,
Load
ratio,
high,
medium-high,
medium-low,
low,
(if condition) as indicator
from "Source".
Please let us know if you face any issues.
Thanks.
thnaks a lot for your reply.
It worked out.