Skip to Content
0

Max value -Foreach function in Webi

Oct 30, 2017 at 03:28 PM

287

avatar image

Hi all,

I have a requirement to get the maximum value based on two dimensions. Below is the data.

data.png

I need to get the maximum "Sequence 2" value for every unique "Planned Year Quarter" in a unique "Project."

Below is the formula I inserted for "Test1" but I get incorrect results.

=Max[Sequence 2] ForEach ([Planned End Year Quarter])) In ([Project])

Can someone please help me with the correct formula.

Thanks.

data.png (12.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Oct 30, 2017 at 03:31 PM
0

try this.

=Max[Sequence2] IN ([Planned End Year Quarter];[Project])
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Amit. It worked.

1