on 2018 Apr 24 11:17 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.