Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Display value from Column

 

I am trying to figure out the best solution to display the value from Order No. If no value in Order No exists, then I would like to display PO No. If there is no value in either, display "Unprocessed". The goal for this is to display an Order No/PO No/ Unprocessed for each item number based off the demand date and the Par location ID it was ordered from. Let me know if additional info is required. Thanks

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    So, a column form of this would be:

     

    Column = 
SWITCH(TRUE()
  ISBLANK([Order No]) && ISBLANK([PO No]),"Unprocessed",
  ISBLANK([Order No[), [Po No],
  [Order No]
)

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    So, a column form of this would be:

     

    Column = 
SWITCH(TRUE()
  ISBLANK([Order No]) && ISBLANK([PO No]),"Unprocessed",
  ISBLANK([Order No[), [Po No],
  [Order No]
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Greg,

       

      This worked great. Thanks

       

      Also just if anyone else uses this solution, don't forget the comma after SWITCH(TRUE( )

      Column = 
SWITCH(TRUE(),
  ISBLANK([Order No]) && ISBLANK([PO No]),"Unprocessed",
  ISBLANK([Order No[), [Po No],
  [Order No]
)