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!
Best answer by Benoit
Hi
I’ve made a reproduction and here the formula I would use for your Test property:
if(CONTAINS('BT: does_not_apply Remap'.Name [by: 'BT: Interchange + Pass Through Transactions'], 'BT: Interchange + Pass Through Transactions'.Description),'BT: does_not_apply Remap'.'Card Type')[remove 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,
+15Hi
I’ve made a reproduction and here the formula I would use for your Test property:
if(CONTAINS('BT: does_not_apply Remap'.Name [by: 'BT: Interchange + Pass Through Transactions'], 'BT: Interchange + Pass Through Transactions'.Description),'BT: does_not_apply Remap'.'Card Type')[remove 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,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
