using wildmatch for two data

ajater2012 · ‎2020-11-23

Hi

I have the total of two different data

for example A and B

the total of A = 100

and the total of B = 200

when I show them in table like this:

account total

A 100

B 200

A is in a table that has a branch column, and B is in a table that has a branch column but I can get branch name

from account name as its written in the last part of the account name by using Right function

I tried this expression:

=If(WildMatch(ACCT_NAME , '*branch1*') ,'branch1' or WildMatch(BRANCH_E_NAME , '*branch1*'),'branch1')

and it worked fine but it show the header -1 but it should be branch1:

account total -1

A 100 50

B 200 60

MayilVahanan · ‎2020-11-23

Try like below

=If(WildMatch(ACCT_NAME , '*branch1*') or WildMatch(BRANCH_E_NAME , '*branch1*'),'branch1')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

ajater2012 · ‎2020-11-23

thanks for the replay I tried your code it solved the header name problem but it gives branch1 the total result

like this:

account total branch1

A 100 100

B 200 200