Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

If not, result error

The formula used is given in the screenshot. If length, width, height >0 then "YES" plus "No" Els

calerof
5 years ago
Hello @sbhan4 ,

Try this:
GPPCheck = SWITCH( TRUE(), SUM(GPP[Height]) <= 0 || SUM(GPP[Lenght]) <= 0 || SUM(GPP[Width]) <= 0, "No", "Yes" )

I hope it helps.
Best regards
Fernando

If it helped, please consider liking the post and mark it in response.

Anonymous

Not applicable

5 years ago

@calerof plz take a look

Impactful Individual

5 years ago

Hello @sbhan4 ,

Try this:

GPPCheck = 
SWITCH(
    TRUE(),
    SUM(GPP[Height]) <=  0 ||
    SUM(GPP[Lenght]) <= 0 ||
    SUM(GPP[Width]) <= 0,
    "No",
    "Yes"
)

I hope it helps.

Best regards

Fernando

If it helped, please consider liking the post and mark it in response.

Anonymous
Not applicable
5 years ago
calerof Hello sir,

I tried your solution. Everything showing "YES" only. As you see in the screenshot,
if any of the column value is 0 or blank = NO
Each column has a value >0 then only YES. can you share your pbix file.
- calerof
  Impactful Individual
  5 years ago
  Hi Anonymous ,
  
  You are doing it the opposite way, and that's fine. You just have to change the OR for AND.
  
  Cheers,
  Fernando
  - calerof
    Impactful Individual
    5 years ago