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
Hello mohsenask ,
could you do yet another calculated column where you concatenate the Merchant, Brand, Fee and and premium? If you do this on both sides, you could get the according fee with a lookupvalue.
Just an idea - hope it helps
hashtag_pete