This discussion is archived
7 Replies Latest reply: May 21, 2013 2:30 AM by Fabien D. RSS

How to display negative numbers with a F1-DE-SINGLE zone

Fabien D. Newbie
Currently Being Moderated
Hello,

I want to display negative values in a SQLCOL column with a F1-DE-SINGLE based zone. Whatever I'm trying, it seems that the system rounds negative values to 0 (result is correct when running the sql query by it self).

At the end I tried a very basic test :

Query:
select...
, (select (-1) from dual "QTE")
...
from...


Column definition :

source=SQLCOL sqlcol=QTE label='QTE'
type=number

The column displays : 0,00

Does anyone has a clue of what's hapenning and of a solution for this ?

Thanks,

Fabien

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points