EPMDimensionOverride with OR/AND logic

[Former Member]

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?

[former_member186338]

Unfortunately "()" are not supported in logical expressions in EPMDimensionOverride

[Former Member]

Thank you! May be any workaround?

[former_member186338]

The only workaround is to create text string like:

=EPMDimensionOverride("000";"INACCT";"2020202020704;ACCTYPE=INC,2020202020703;ACCTYPE=INC,2020202011005;ACCTYPE=INC")

[former_member186338]

; - AND

, - OR

[former_member186338]

To generate the line you can use this formula: