Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @ajater2012
Try like below
=If(WildMatch(ACCT_NAME , '*branch1*') or WildMatch(BRANCH_E_NAME , '*branch1*'),'branch1')
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