Request for help with a "Max()" related problem...

[Former Member]

Hi all, thanks in advance for spanding time on reading my question!

I am trying to calculate a "max" value for a list of data in WebI however I can't figure out the right combination of Max() with either ForEach or In... I've tried many different combinations but never get what I'm looking for...

This is a heavily simplified example of the data I'm working with:

So, I'm looking to get 1 value (max of 'Duration') for each 'Parent Ticket'...

Could anybody on this community please help me out?

Thank you very much in advance!

Bernard.

[antonette_oberholster]

Hello Bernard

What happens if you try this:

=Max([Duration] In ([parent ticket]))

Regards

Antonette

[Former Member]

Hi Antonette,

Thanks for the suggestion - however that returns a "multivalue" error...

B.

[Former Member]

Please ignore my previous comments... It doesn't work...

I get a "172.4" everywhere

I don't understand why - this was the behavior I've seen earlier and why I raised the question here...

Now, I got it to work because (in one of my previous trials) I had created an intermediate column between DURATION and MAX DURATION and added a 'runningmax'.

With the following formula: runningmax(duration;(parent ticket)) in the RUNNINGMAX column, I get:

I'm already happy that it works but I would like to understand why I need that intermediate step...

Any ideas?

[Former Member]

I made a small mistake in my last sample sheet:

the last 2 numbers in Duration should be "8.43333333"

Like this:

[amitrathi239]

use Foreach.

=max(duration) foreach( child ticket) in (parent ticket)

[Former Member]

Hi Amit,

with your suggestion, I get the same result as my "duration" result

[amitrathi239]

try this.

=max(duration) in (parent ticket)

Makesure your duration object data type should be number.

[Former Member]

Hi Amit,

I feel so stupid now 🙂 - that worked... I am so sure I tried this before... could be that I tried the following:

=max(duration in (parent ticket))

and that didn't work as it gave me a MULTIVALUE

Thank you Amit... Really appreciated...

[Former Member]

And just one more question 🙂

If I remove "CHILD TICKET" from the block, the overall result changes because of the missing dimension...

How could I still calculate the same value but by referencing the 'CHILD TICKET' dimension directly in my formula?

Thanks