How to show a zero which is NOT a default value ?

Messen
Messen Member Posts: 4
edited 2004-06-22 in Navision Attain
In a table I have a decimal field. Default value is by system zero. I would like this field to be blank, because we use this field as a result e.g. 0.00. But the default zero is not a result for us. So we will only like to see the zero when we have entered the zero by ourselfes and not the default.

Can anyone help ? :wink:

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    When you set the BlankZero-property of that field to Yes, it will always be blank, also when you manually enter 0.
    So you could better use the BlankNumbers-property with the value BlankNeg and make sure your default value is eg. -1. This is only possible of course if all your results are >= 0.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Messen
    Messen Member Posts: 4
    Hey Luc,

    Tx for your prompt reply. And yes - your solution was also my first workaround, but off course the users need to enter neg. figures :roll: Any other solutions ?
  • RobertMo
    RobertMo Member Posts: 484
    You would desperatly need 'Null' value... No go... :(

    What about Additional (boolean) field "Manually Entered". FALSE by default and on validate of your numeric field you can set it to TRUE.

    When displaying numeric filed you refer to this boolean field in OnFormat trigger of numeric field control...
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • Messen
    Messen Member Posts: 4
    Hi,

    Sorry for my late answer...

    TX for your answer. I will try your sultion with the Boolean filed. Have heard from secondhand that this is the best solution for my "problem". Thank you :-)

Categories