Hello!
I would like to use "=EPMDimensionOverride(" for a couple of accounts, that must be filtered by attribute.
So, now my formula looks like:
=EPMDimensionOverride("000","ACCONT",A1 & "AND ATRIBUTE=X"), where
A1 - is a cell with accounts (defined dynamically), that separated via ","
So, logic of my formula works this way - acc1 OR acc2 OR acc3....OR accN OR (accN+1 AND ATRIBUTE=X)
I need this logic - (acc1 OR acc2 OR acc3....OR accN OR accN+1) AND ATRIBUTE=X
Have you any idea how to write this logic and is it possible at all?
Unfortunately "()" are not supported in logical expressions in EPMDimensionOverride
Thank you! May be any workaround?
The only workaround is to create text string like:
=EPMDimensionOverride("000";"INACCT";"2020202020704;ACCTYPE=INC,2020202020703;ACCTYPE=INC,2020202011005;ACCTYPE=INC")
; - AND
, - OR
To generate the line you can use this formula: