If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

avoiding negative sign '-'

Started by pooja, 18 Jun 2010 12:35:07 PM

Previous topic - Next topic

pooja

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

kattaviz

Hi,

Use abs([data_A] - [data_B]) which will return positive number.
thanks & regards
Satish Katta