Skip to main content

Hi!

 

Can you please help creating a formula for below? 

 

In <BT: Interchange + Pass Through Transactions> transaction list  &  <Card Type> property dimension “does_not_apply” only, review <Description> property text and populate the <Card Type> dimension in <Text> property if the <Description> property contains the text listed in the <BT: does_not_apply Remap> transaction list?

 

Thank you!

Hi @Yaejis ,

 

I’ve made a reproduction and here the formula I would use for your Test property:

if(CONTAINS('BT: does_not_apply Remap'.Name aby: 'BT: Interchange + Pass Through Transactions'], 'BT: Interchange + Pass Through Transactions'.Description),'BT: does_not_apply Remap'.'Card Type')premove firstnonblank: 'BT: does_not_apply Remap']

 

 

Please note that my  'BT: does_not_apply Remap' is a dimension list and not a transaction list.

If you need, you can convert a transaction list into a dimension list using the settings.

 

Hope this helps!

Best,

It worked! thank you so much

Reply


Ask your question here!

Terms & ConditionsCookie settings