avatar image
Former Member

EPMDimensionOverride with OR/AND logic

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 17, 2017 at 04:34 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 17, 2017 at 04:48 PM

    The only workaround is to create text string like:

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

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content