negatives as zeroes

[tupac_rd]

Hi Gurus,

How do we display negative numbers as zeroes in Report Studio report.

Thanks
2pac

[tupac_rd]

that was easy, I was having issues because I a using Lotus notes db, and the numbers are stored as text, and if I do a cast(integer) was not working... so I instead said if ([d1] starts with '-') then ('0') else ([d1])

[mvjcognos]

case when (quatity<0) then (0) else (quantity)

[tupac_rd]

Sorry, the data is stored as text, and '<' is not working....

[mvjcognos]

try with boolean or string variable

case when quantity='zeros' then ('0') else quantity end

then click on the column assign the variable ........