topic Re: IF Condition using Then in Developer

IF Condition using Then

SIBI1998 — Mon, 07 Mar 2022 08:10:45 GMT

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 .

How do I got the Solution.

Re: IF Condition using Then

arvindsingh802 — Mon, 07 Mar 2022 14:20:14 GMT

Create a Measure
Dummy = Sum(Act Ucc Cnt)

Then in next measure where you nee the value (I have added secound else as Less than 1)
Value = IF([Dummy] >= 5, "Greater than 5", IF([Dummy] < 5 && [Dummy] >=1 "Less than 5", "Less than 1"))

Re: IF Condition using Then

truptis — Mon, 07 Mar 2022 21:27:39 GMT

Create a measure:
Result = var m1 = Sum(Act Ucc Cnt)
return
if(m1 >= 5,"Greater than 5", if(m1 >=1 && m1 <5","Less than 5","N.A."))

If this post solves your query, then please accept it as a solution to help other members find it faster. Also, hit a thumbs up. Thanks.

Best Regards,
Trupti S

Re: IF Condition using Then

Anonymous — Tue, 08 Mar 2022 11:14:57 GMT

Really helpful