Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I was trying to do the following statements using Set analysis instead of If.
Can someone help me in getting the same expressions using Set analysis.
If(RangeStdev( [V1], [V2], [V3])<=5, 'Good', 'Alert')
If( IsNull([V1]) or [V1]<=1 or IsNull([V2]) or [V2]<=1 or IsNull([V3]) or [V3]<=1, 'Threat', 'No Threat')
Set analysis can not branch. It can only filter. Your if statements do branch so you cannot replace them with set analysis expressions.
Set analysis can not branch. It can only filter. Your if statements do branch so you cannot replace them with set analysis expressions.
Thanq verymuch Gysbert.
Learnt new thing