Skip to Content
avatar image
Former Member

BPC input form display blank if value is deleted & also save zero

Hi,

We have an input form (for targets):

  1. For some parameters user wants to enter target as 0.
  2. If user enters some wrong value & deletes it, he wants it to be displayed as a blank cell for entering value later. So he can identify the cell (blank) where value needs to be entered. (which by default is shown as 0 when deleted)

Combining the above 2 is a problem as the user wants to differentiate between target=0 & the value he deleted.

Please suggest a solution

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 24, 2016 at 06:37 AM

    Hi Mihir,

    Answers as per points...

    1. User can enter 0 as target(blank cell) by keeping the setting from options -->Formatting ---> Report Format---> Set default value in empty cell. But note that this value wont be saved to the database! It would just show "0". For this refer to no. 2 in the screenshot Changed report.

    2. For this requirement, I am thinking you can use "Changed member format" in this case. If the user deleted existing data then the color of the cell will change and it will highlighted. But after hitting the Save data button this highlighted cell would come back to the normal format given!. So user would only come to know about the deleted data before saving! refer to no. 1 in the screenshot.changed-member.pngchanged-report.png

    Let me know if this works for you...

    Regards,
    JP

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2016 at 08:55 AM

    "For some parameters user wants to enter target as 0" - incorrect idea in general. In bpc empty and zero record are assumed identical in many cases. Also after light optimize with zero elimination zero records will be deleted.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2016 at 06:50 AM

    Thanks JP & Vadim.

    This is what I have done:

    I used the EPM save comment formula [=IF(SEARCH("0",F10)=1,EPMSaveComment(F10,,EPMMemberID($B10),EPMMemberID($C10),EPMMemberID(F$9)),"")].

    If the cell contains 0 then it will save it as a comment else keep it blank.

    This way even if a value is deleted a blank is shown & when the user enters a 0 it is saved as a comment.

    Also I ran Light optimization before this to eliminate all 0 records.

    This is working for my requirement.

    Please let me know if there is any issue with the above solution.

    Regards,

    Mihir

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      I will not be providing that solution. It was just a manipulation of sorts.

      I will speak with the customer about it.

      Thanks.