Forum Discussion

SIBI1998's avatar
SIBI1998
Helper I
4 years ago
Solved

If condition Using Then

Hi Team,             If Sum(Act Ucc Cnt) >= 5 then I need an Output as Greater than 5 ,              If Sum(Act Ucc Cnt) < 5 and Sum(Act Ucc Cnt) >=1 then I need an Output as Less than 5 .   Ho...
if condition
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi SIBI1998 ,

     

    Try this:-

    Measure = 
Switch(true(),
Sum(Act Ucc Cnt) >= 5,"Greater than 5", 
Sum(Act Ucc Cnt) < 5 && Sum(Act Ucc Cnt) >=1,"Less than 5"
)

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi SIBI1998 ,

 

Try this:-

Measure = 
Switch(true(),
Sum(Act Ucc Cnt) >= 5,"Greater than 5", 
Sum(Act Ucc Cnt) < 5 && Sum(Act Ucc Cnt) >=1,"Less than 5"
)

 

Thanks,

Samarth