Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an If statement that I am using that works well and an Only expression that works, but I am having trouble combining them. Can anyone help me figure out the correct way to combine these into one expression?
IF(Significance_Industry >=.6,'H',IF(Significance_Industry < .3,'L'
,IF(Significance_Industry < .6 and Significance_Industry >= .3,'M','L'))))
only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry)
May be this:
If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) >= .6,'H',
If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) < .3, 'L',
If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) < .6 and
Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) >= .3, 'M', 'L'))))
May be this:
If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) >= .6,'H',
If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) < .3, 'L',
If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) < .6 and
Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) >= .3, 'M', 'L'))))
Thank you that worked great, I just had to remove one of the parenthesis at the end. One too many it seems. I really appreciate the help.