Forum Discussion

randyrettig's avatar
randyrettig
Icon for Helper I rankHelper I
2 years ago
Solved

If, Then formula

Hi all,

 

I need help with a formula/new column.  Basically, if orderprocess[groupno] = 9, and orderprocess[vendorID] has a value, and orderprocess[partnumber] is not 0, return YES, else No.

 

What I'm trying to do is create a new column that just says Yes or No according the above rules.

 

I need some inspiration, I'm stuck!

 

Thanks!

Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello randyrettig ,

     

    use the following calculated column

    new column = IF(orderprocess[groupno] = 9 && orderprocess[vendorID] <> BLANK() && orderprocess[partnumber] <>0 , "Yes","No")

     

     

    The pbix file that I used to create the formula for your reference.

2 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    2 years ago

    Hello randyrettig ,

     

    use the following calculated column

    new column = IF(orderprocess[groupno] = 9 && orderprocess[vendorID] <> BLANK() && orderprocess[partnumber] <>0 , "Yes","No")

     

     

    The pbix file that I used to create the formula for your reference.