Skip to Content
avatar image
Former Member

Getting Ranking issue for Time based on Max position

Hi All,

In my Webi Report, I need to show the time when the position is maximum in a day of the month.

Here as shown in the screen for Largest Positive Position (LPP) I have added Ranking as Top 3 based on the position.

I am getting #Multivalue error when I use formula =[Time] ForEach ([*LPP]).

Where, [*LPP] =Max(RunningSum([Amounts];... [Day])) ForEach([Time];...) In ([Day]))

Any help is appreciated.

Regards,

Shrutika

RankTime.PNG (12.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 03, 2015 at 02:22 PM

    Hi,

    try something like this.

    =[Time]  where ([Amounts])=([*LPP])


    Amit

    Add comment
    10|10000 characters needed characters exceeded