Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi expert
Need to build some master items with restrictions on two dimensions. Is this possible. The following script is a sample for this challenge:
if(Account={'9900', '9901'} and CostCenter={'10', '20'}, 'ABCDE')
Any ideas?
Thanks, Tom
solved:
=if(Account=('9900') or Account=('9901'), if(CostCenter='10' or CostCenter='20', 'ABCDE'))
You can also try to use functions like Wildmatch and match like below to simplify your expression.
if(match(Account,9900,9901) and match(Costcenter,10,20),'ABCD')
Yes, you can create a calculated dimension and make it a master dimension. Its possible to use the same function you have written
Thanks, but with this formula I am getting an error:
solved:
=if(Account=('9900') or Account=('9901'), if(CostCenter='10' or CostCenter='20', 'ABCDE'))
You can also try to use functions like Wildmatch and match like below to simplify your expression.
if(match(Account,9900,9901) and match(Costcenter,10,20),'ABCD')