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!
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.
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.
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.
Haven't worked much with Analysis Studio. It may be worth a try to post this question on the Analysis Studio forum.