topic using wildmatch for two data in App Development

using wildmatch for two data

ajater2012 — Mon, 23 Nov 2020 07:47:19 GMT

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 — Mon, 23 Nov 2020 08:04:54 GMT

Try like below

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

ajater2012 — Mon, 23 Nov 2020 08:16:17 GMT

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