Skip to Content
avatar image
Former Member

Different Excel formula in different columns of a local member row...

I have a need to use different (Excel) formulas in different columns in a local member row for a dynamic report. The layout looks like:

How do I achieve it using a local member formula? or otherwise.

loc1.PNG (9.1 kB)
loc1.PNG (9.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 30, 2014 at 08:56 AM

    Hi Coomar,

    There is no general solution for all cases, but you can use Excel functions to determine the column:

    =IF(COLUMN()=7,...,IF(COLUMN()=8,...,...

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 05:59 PM

    Vadim,

    Thanks. I was able to do that.

    I have another questions:

    If I have a local member that is attached (either through "Insert before" or "Insert after") to a EPMOLAP member  and I have "Remove Empty & Zero Values" checked, is the local member also supposed to vanish when there are zero or empty values for the EPMOLAP member? Apparently it is happening in my case.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded