Skip to Content
0

Offset value in Webi report

Apr 24 at 10:17 PM

26

avatar image
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.

10 |10000 characters needed characters left characters exceeded

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

0
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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Apr 25 at 04:01 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded