Forum Discussion

mohsenask's avatar
mohsenask
Icon for Helper II rankHelper II
4 years ago
Solved

Calculated column with IF...Else statement

Hi    I have the following tables; only mentioning relevant columns here Merchants with columns CompanyID MerchantName AllTransactions PaymentIntentId CompanyID Fees BrandName IS_Premium (...
Need Help
  • hashtag_pete's avatar
    hashtag_pete
    4 years ago

    Hmm,

    this gets very theoretical without actual tables, but you can include in the CONCATENATE formular the LOOKUPVALUE, such as 

    "New Column" = CONCATENATE ( LOOKUPVALUE(...), ChargeID , BrandID , Fee_Type (domestic/international), Is_Premium)

    not quite sure if I am loosing it here 😄

     

    hashtag_pete

hashtag_pete's avatar
hashtag_pete
Icon for Helper V rankHelper V
4 years ago

Hmm,

this gets very theoretical without actual tables, but you can include in the CONCATENATE formular the LOOKUPVALUE, such as 

"New Column" = CONCATENATE ( LOOKUPVALUE(...), ChargeID , BrandID , Fee_Type (domestic/international), Is_Premium)

not quite sure if I am loosing it here 😄

 

hashtag_pete