How do you add a blank member into an EPMDimensionOverride formula?

[Former Member]

Hi-

I have gotten a good handle on using EPMDimensionOverride, but am unable to figure out how to add a blank member to the formula with the correct results.  I have it set up so the user chooses the current month they want to report on, and the EPMDimensionOverride formula will list all months in the year prior to that month, plus the month chosen so that they can get a trend report.  Any ideas?

[Former Member · Accepted solution]

OK, so I did some digging and found the answer myself.  In order to add a blank member in a dimension override, simply put ,"" in your formula.  For instance, here is a member list formula that includes a blank member:

D9&","&D10&","&D11&","&""&","&""&","&""&","&""&","&""&","&""&","&""&","&""&","&""

Where D9, D10 and D11 are id's for members in a time dimension

[former_member228878 · Accepted solution]

Good One, its working thanks Steven