Forum Discussion
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 (...
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
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