Getting Ranking issue for Time based on Max position

[Former Member]

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

[amitrathi239]

Hi,

try something like this.

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

Amit

[Former Member]

Hi Amit,

I tried the same, It didnt work.. any other suggestion you have ?

Regards,

Shrutika