Skip to Content
Former Member
Mar 04, 2010 at 05:03 PM

Reverse Sign of Hierarchy Nodes does not work in query


I have been working on an issue with Reverse Sign for a hierarchy without any luck....

I have created a hierarchy that has some nodes with Reverse Sign Checked off, but when I run the query the values are the same as if I didn't check it off. I understand that I can multiply a Key Figure By -1, but my issue is that in the hierarchy i have some nodes that i don't want the sign to be reversed and a few that i do want reveresed. I have a report with about 30 key figures and I want those values to be negated only for the nodes of the hierarchy I have marked with Reverse Sign. Any help would be appreciated. Thanks.