using wildmatch for two data

[ajater2012]

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]

Hi @ajater2012 

Try like below

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

[ajater2012]

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