Comment appearing in unrequired cell of BPC report

[former_member590808]

Hi

I have 2 sheets BPC_SAVE and BPC Template in a BPC report. In BPC Template I have a formula as EPMSaveComment(Format!D11,,"NOGL",Format!J11,BPC_SAVE!F11,348,"PLAN_REV1",BPC_SAVE!$F$4,BPC_SAVE!$F$5,BPC_SAVE!$F$6,"CPT"). I am trying to retrieve a value with this comment in cell J11, the value gets retrieved in J11 but also appears in D11 cell of BPC Template. I dont want the value to appear in D11 cell. Is there a way to achieve this ?

BPC report's row starts from E11

Screenshot for reference:

[former_member186338]

Sorry, but please, show formula in each cell!

[former_member590808]

We have 2 sheets Format and BPC Template.

cell J11 of BPC Template sheet(screenshot attached) has formula EPMSaveComment(Format!D11,,"NOGL",Format!J11,BPC_SAVE!F11,348,"PLAN_REV1",BPC_SAVE!$F$4,BPC_SAVE!$F$5,BPC_SAVE!$F$6,"CPT") which has NA value stored in that combination.

Cell D11 in BPC Template sheet has no formula but the value getting derived from above formula is appearing in D11. I don't want this NA to appear in D11 cell

[former_member186338]

Still not 100% clear:

BPC_SAVE - is it the 3rd sheet?

[former_member590808]

Yes,it is the 3rd sheet where the data is initially getting saved from format template.

Format template: Plain excel sheet which will have data in it

BPC_SAVE sheet is a bpc sheet which is used for saving the data in Format template as BPC comments

BPC Template sheet is where I am trying to retrieve the data saved in BPC_SAVE sheet.

cell J11 of BPC Template sheet(screenshot attached) has formula EPMSaveComment(Format!D11,,"NOGL",Format!J11,BPC_SAVE!F11,348,"PLAN_REV1",BPC_SAVE!$F$4,BPC_SAVE!$F$5,BPC_SAVE!$F$6,"CPT") which has NA value (NA was written in format sheet and saved via BPC_SAVE sheet and now am trying to retrieve that comment via local member in BPC Template sheet).

Cell D11 in BPC Template sheet has no formula but the value getting derived from above formula is appearing in D11. I don't want this NA to appear in D11 cell

[former_member186338 · Accepted solution]

If you want to retrieve comment - then use:

EPMCommentFullContext

For EPMSaveComment it's prohibited to use first parameter on another sheet:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.38/en-US/f9bcfd0c6faf1014878bae8cb...

"Cell in which the comment is retrieved/entered. The cell must be on the same worksheet as the EPM function. Mandatory."

[former_member590808 · Accepted solution]

I tried to use EPMCommentFullContext and yet the value is appearing in cell D11. I dont want value to appear in D11 cell. Cell D11 has no formula.

[former_member186338 · Accepted solution]

nehayadav0911

Sorry, but you are doing something wrong...

EPMCommentFullContext will never write to column D

Look on your other formula to Save comment, may be on some other sheet...

Try to create report from zero!

[former_member590808 · Accepted solution]

working! Thanks Vadim.