cancel
Showing results for 
Search instead for 
Did you mean: 

Offset value in Webi report

Former Member
0 Kudos
752

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
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

jyothirmayee_s
Active Contributor
0 Kudos

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