EPMInsertCellsBeforeAfterBlock

[Former Member]

Hello Experts,

could somebody please xplain me how this formula works? I can't manage it

Everything I do it does not work. I do not have a requirement, I just want to understand how this works and how the formula has to be integrated in the report. Unfortunately, as usual at SAP, there is no useful help available.

There is a similar thread on SCN, but to be honest, I cant get this work.

http://scn.sap.com/thread/3334021

Ty in advance,

Karsten

[Former Member · Accepted solution]

Hello all,

this is not possible. Both, ";" and "FALSE" are automatically generated by the system. I am not able to change this. If I type the formula directly I get the message "Formula contains errors". If I Change via formula dialogue, the signs (Quotation marks and semicolon) are automatically set.

Any ideas?

[former_member186338 · Accepted solution]

Ups, not FALSE but FALSCH

Excel 2007 function name translations - English-German

[Former Member · Accepted solution]

Vadim, u are my personal god

Now it works. This behaviour is complete crap. If you use local members and you put a formula in, you have to use the english formula to get it work - even if you have a german Excel. For the formula in this case you have to use the german format of the formula.

I really dont know who inplemented this impressive logic

Thank you again,

Karsten

[former_member186338 · Accepted solution]

I can easily explain the reason:

With normal EPM formulas you have to use local constants names like FALSH - same behavior as with other Excel formulas.

With local members the EPM is using something like in VBA:

Range(A1).Formula = "= A2+A3"

And it's VBA (and NET) limitation - the formula text has to be in US format!

Vadim

[former_member186338 · Accepted solution]

Ups, looks like EPM developers forgot about:

Range(A1).FormulaLocal = "= A2+A3"

With this property the local member will be entered with local syntax

Vadim

[Former Member · Accepted solution]

Hello Vadim,

ty again for your helpful advise

Best regards,

Karsten

[former_member186338]

Hi Karsten,

First - Block - means that you have at least 2 dimensions in row or column axis. Look on the sample - 2 dimensions in row axis: CORPDIR and INACCT:

In C4:D4 you can use Excel formulas etc...

Vadim

Message was edited by: Vadim Kalinin Correction - C4:D4!

[former_member186338]

P.S. If you select C4:C4 - single value will be distributed, etc... just play with sample like this!

Vadim

[Former Member]

Hey Vadim,

thank you for your answer.

This is exactly my problem - the case you describe does not work for me. I always get a #VALUE error in the epm formula. Please see the screenshot:

Any ideas?

Thank you in advance,

Karsten

[former_member700949]

Hey Karsten,

Try to replace ";" in your formula by ","

Hope it helps.

Regards,

Vishal Ghag

[former_member186338]

Not "FALSE", but FALSE

Vadim

[former_member186338]

Hi Vishal,

In Germany the Excel formula parameter separator is ";"

Vadim

[former_member700949]

Thanks Vadim.