Question on local member formula

[Former Member]

Hi experts,

I have a question regarding local member formula.

I write a local member formula for total, but I want to exclude this formula for last 4 accounts, because those accounts retrieving data for YTD ,so i want to exclude , Is this possible?

Acoounts are dynamic , and columns are fixed.

                      Coulmn B  Coulmn C     Column D

                      2015.01     2015.02        2015.03       total(Local memeber formula)

                      Apr            May              Jun          =sum(B+C+D)

Acnt 1                     10               20                30                 60

Actn2                       20              30                 40                90

Acnt 3                    40               50                   60               150 (I don't want total here)

      150

Acnt4                      50               60                   70               180 (I don't want total here)

Can anyone help me on this?   Thanks.

Regards,

Srikant

[Former Member]

simply use the EPM formatting sheet and set the font color to the same as the backgroud color for those cells.

[former_member186338]

Ups, bad idea to my mind I know one finance director who is ready to kill a person creating Excel reports with white numbers

[former_member186338]

Not clear:

"Acoounts are dynamic , and columns are fixed."

"I want to exclude this formula for last 4 accounts"

may be you want to calculate nothing for YTD accounts?

then use condition in local member formula:

=IF(OR(EPMMemberProperty(,EPMDIM_CURRENT_MEMBER(ACCOUNT),"ACCTYPE")="AST",EPMMemberProperty(,EPMDIM_CURRENT_MEMBER(ACCOUNT),"ACCTYPE")="LEQ"),"",SUM(...))

Vadim

[Former Member]

Hi Vadim,

Sorry for the confusion. I have an input template like this.

We override accounts based on some condition,i.e why i said accounts are not static.

From the below, the headcount figures comes from another template.I don't want total for the headcount accounts. Hope you got my point.

                         Apr-16       May    Jun...         Mar17              total

400000              1                2        3                                      sum(Apr16..to Mar17)

400001              2                3         4                                     sum(Apr16..to Mar17)

Headcount 1   1                  1             1...                                 -

Headcount 2   2                   3             4                                   -

headcount  3   5                  4               5                                   -

Kind regards,

Srikant

[former_member186338]

"headcount figures comes from another template" - how?

Please spend some time to clearly explain the report design... including dimensions, members formulas etc...

[Former Member]

Hi Srikant,

You can write a simple IF condition here, if the accounts are few...like

=IF(C1="Acnt3"OR C1="Acnt4","",Sum(B+C+D))

where C1 is the account column starting cell....

Hope this helps....

Regards,

JP

[former_member186338]

Actually the topic author don't want to exclude fixed accounts

[Former Member]

Agreed....Not fixed! But definately he must be knowing the accounts to be escaped...:) So suggested that method.

[former_member186338]

It can be a VERY long list of all Balance Sheet accounts

[Former Member]

Yes!.....its true but the author himself is saying....."the last 4 accounts". So I guess he has limited accounts. I have mentioned in my post that If the accounts are few he can write that condition.