Skip to Content
0
Apr 04, 2012 at 08:25 AM

Webi RelativeValue with BEx query universe

32 Views

Hi,

I'm new in webi and I have some problems with RelativeValue function.

I'm working with BEx query universe and I want to calculate real amount of the previous fiscal year.

=RelativeValue([Real];([Ejercicio - Clave]);-1) where [Ejercicio - Clave] is, for example, K2/2012 (fiscal year depends of fiscal variant).

Format table:

Rows = [Ejercicio - Clave]

Column1 = P&L Structure

Column2 =RelativeValue([Real];([Ejercicio - Clave]);-1)

And it doesn't work. Anybody knows if format of fiscal year is the cause of the problem?

Thanks.