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

reversing sign

Started by Jeka, 21 Oct 2008 05:12:24 PM

Previous topic - Next topic

Jeka

Hello,

Hello,

I reversed the sign for some account nodes in the Transformer 8.3 to show those nodes as positive amount. Originaly it comes in as negative.
It worked, i see the amount as positive instead of negative!
BUT when I open Analysis Studio and check the cognos generated total the generated total sign is not reversed. Eg:
20000.00 (shows positive amount, the original amount is negative)
10000.00
Cognos Total (10000.00)

Is it possible to show cognos total as positive number?

Thank-you!

bonniehsueh

#1
There are a few ways to do this. Depends on how you plan on using this number.

If used in a calculation, you can use:
abs()
Case statement

If not used in a calculation, then it can be addressed in formatting properties.

You can find examples on Cognoise by searching on keywords with 'negative', 'reverse', 'sign', etc.

Jeka

Thank-you for your reply BUT I'm using Analysis Studio not Report Studio.

I have something like this in AS.

Revenue      20000.00 (this number is a negative number but i reversed the sign in Transformer)
Expense      10000.00
Cognos Total (10000.00)


Any thoughts?
Thank-you.

Jeka

FYI...

Reversing the sign does not affect the value properties, only how they appear in your OLAP reporting
component. However, your report users should be advised that sign reversal can alter the results
of run-time calculations. We recommend that you state which categories contain reversed signs in
the Description box of the Measure property sheet, thereby ensuring that this important information
is shared with the appropriate users.

bonniehsueh

Haven't worked much with Analysis Studio. It may be worth a try to post this question on the Analysis Studio forum.