on 08-15-2020 3:25 PM
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:
If you want to retrieve comment - then use:
EPMCommentFullContext
For EPMSaveComment it's prohibited to use first parameter on another sheet:
"Cell in which the comment is retrieved/entered. The cell must be on the same worksheet as the EPM function. Mandatory."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
User | Count |
---|---|
11 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.