Offset value in Webi report

[Former Member]

Hello Friends,

How to use offset value in webi?

In excel :AVERAGE(OFFSET(J1,,,J300,1)) works fine. I need exactly same in webi to specify the offsetvalue. Greatly appreciated for your help.

[former_member198519]

What exactly are you trying to achieve? Can you provide some sample data?

[Former Member]

Hi Kuldeep,

My requirement is to show - Top1% (Minus Top 1%) in webi report

RegionAverage DaysTotal ReceiptsMinus Top 1%AA44.54FF45.65

Please help me with minus Top 1% calculation

[jyothirmayee_s]

Hi,

Try RelativeValue() function.

Example: RelativeValue([Revenue];([Year]);-1)

The offset is -1 (the function returns the immediately previous value in the list).

Thanks,

Jothi