Forum Discussion
Calculated column with IF...Else statement
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
mohsenask , You have like
I think in payout Table
Switch( True() ,
[Fee_Type] = "international" && related(MerchantName) = "XXX" && related([BrandName] ) = "YYY" & [ChargeId] = "ZZZ", True() ,
// Add more conditions
false()
)
related can be used from one to Many size else use alternatives
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Is that column ??
Also how does this connect and derive perc_amount?