This content has been marked as final. Show 2 replies
Hello,1 person found this helpful
I think that you will have to change the datatype field to CHAR, then handle your self the format.
To remove the trailing point, use the RTRIM( value, '.') function.
Looks like there is not a simple solution using a format mask alone.
I have implemented a very similar solution to your suggestion. I have a character, non-base table field which I populate and dynamically set a format mask if the value is between -1 and 1 (and not zero).
if :purchase.qty > -1 and
:purchase.qty < 1 and
:purchase.qty != 0
:purchase.qty__dsp := to_char(:purchase.qty,'FM999999990D99');
:purchase.qty__dsp := to_char(:purchase.qty);