Skip to Content
avatar image
Former Member

BPC NW version 10 : EPM Excel : manage empty comment

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 24, 2017 at 01:33 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2017 at 01:52 PM

    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

    Add comment
    10|10000 characters needed 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!

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

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

    Add comment
    10|10000 characters needed characters exceeded

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

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

    Add comment
    10|10000 characters needed characters exceeded