In EPBCS MDX Outline formula, is there a way to use the Except Function after When IS Function? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

In EPBCS MDX Outline formula, is there a way to use the Except Function after When IS Function?

in EPM Platform and Freeform 11 comments

For example I have the below Account formula and it shows values for all brands within Pillar_220, yet I want to exclude certain brands (that roll up to other Pillars). Can I use Except to do this and what is the syntax?

FORMULA

WHEN IS ([Scenario].CurrentMember,[OEP_Forecast]) AND ISLEAF([Item].[Total Item].[All Item].[Pillar_220].[1415].[1415 Input])

THEN

([Account].[OFS_Financials Accounts].[OFS_Expense Planning].[OFS_Total Expenses].[60000].[60100].[60200].[60300].[60330])

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!