Skip to Content
avatar image
Former Member

Offset value in Webi report

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.

Add comment
10|10000 characters needed characters exceeded

  • 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

  • Get RSS Feed

1 Answer

  • Apr 25 at 04:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded