Skip to Content
0

BPC NW version 10 : EPM Excel : manage empty comment

Oct 24, 2017 at 12:43 PM

98

avatar image
Former Member

Hello,

I use the EPM Excel

I use the function EPMsavecomment

By defaut , BPC give 3 points : ...

According to ' users options' , I managed the fields 'empty Comment' without nothing

Accordind to EPM sgheet options , I managed the field 'empty cell default value' with 0 value

Question : Why BPC indicates 3 points ....

See the file above

empty-comment.png

Thanks

Bastien

empty-comment.png (93.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Oct 24, 2017 at 01:33 PM
0

First - incorrect question tag - has to be

EPM Add-In for Excel

Please, correct!

"Accordind to EPM sgheet options , I managed the field 'empty cell default value' with 0 value" - no relation to EPMsavecomment

"Question : Why BPC indicates 3 points ...." - looks like you already saved "..."

Clear CK column and save comments!

Show 1 Share
10 |10000 characters needed characters left characters exceeded

P.S. Just tested:

"According to ' users options' , I managed the fields 'empty Comment' without nothing"

And saving empty comment I can clear anything in the comment.

comments.png (33.3 kB)
0
avatar image
Former Member Oct 24, 2017 at 01:52 PM
0

Hello Vadim,

I understand your solution.

But BPC added automatically 3 points ... .

I saved the 3 points but I never entered theses 3 points

For example, for the same input date, BPC added the 3 points see file above

Question : how to stop BPC to add 3 points

table-comment.png


table-comment.png (130.3 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

First - the tag is not corrected! OK, moderator alerted.

Second: explaining again: "..." is already saved! To clear it you have to save empty comment for the same intersection of members!

Create a test report with a single line and single EPMsavecomment and try!

0
avatar image
Former Member Oct 24, 2017 at 01:55 PM
0

NB : If I saved the fields comment by 'blank' (emplty) , BPC add 3 points again....

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but if you don't want to correct the question tag I see no reason to continue...

0
avatar image
Former Member Oct 24, 2017 at 02:14 PM
0

for information, see the note note-1852481.png and my settings


note-1852481.png (87.4 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

And it's working in my system absolutely fine. No issues at all!

0