COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pooja on 18 Jun 2010 12:35:07 PM

Title: avoiding negative sign '-'
Post by: pooja on 18 Jun 2010 12:35:07 PM
is there any way to avoid neagative sign on report.
we have a report calculation [variance_amount] where
we calculated [data_A] - [data_B], which gives correct results.
but we are getting some value with negative sign (-).

we wonder if there any way not show '-' sign

thakx in advance for any help
Title: Re: avoiding negative sign '-'
Post by: kattaviz on 18 Jun 2010 02:03:57 PM
Hi,

Use abs([data_A] - [data_B]) which will return positive number.