Skip to Content
0
Former Member
Nov 30, 2009 at 09:22 AM

New Calculated measures with reverse sign on a univ/BEx with a structure

35 Views

Hi,

Trying to create a new calculated measure in my universe that is supposed to flip some values.

The new key figure setup looks like this :

Type : NUMERIC

Select: <EXPRESSION>@Select(Key Figures\Actuals YTD)*-1</EXPRESSION>

Measure object

Associate a list of values is deselected.

Function : Database delegated

When doing this on a BEx query/universe without the structure it works fine, and opposite when doing it on

one with a structure i dont get any data !.

Version : BOBJ XI 3.1 Service Pack 2

Any suggestions ?

Rgds,

Kim