how to Get Max value

[Former Member]

Hi Experts

I am stuck with with a problem unable to find solution . i want to find maximum value for this

material Ordernumber  Operation KEy        measurevalue
aaa            55                  20                     0
aaa            55                  30                    0.44
aaa            56                  10                    6.59
aaa            56                  20                       0
aaa            56                  30                    1.82 

i want the maximum value for each order number like .For order number 55 max value is 0.44 and for 56 is 6.59 . both gets summed and display in material 7.03

finally i want the table like this

material   measurevalue
aaa              7.03

Please suggest the answers ASAP ..its urgent

[arijit_das · Accepted solution]

Take Material, Order No as dimension and use the formula below as the measure:

=Max([measurevalue] ForEach ([material];[Ordernumber];[Operation KEy]))

Make sure that you have Material, Order No, Operation Key and measurevalue in the webi query.

[Former Member · Accepted solution]

Hi

Thanks for reply

I am getting multi value error when i written a formula , when i added the order number then it retrieved the maximum value from operation key . and i want to sum it up on on material i mentioned above example . could u please help out to overcome this issue

[arijit_das · Accepted solution]

Do you want the sum of the maximum figures ?

Then just use material dimension and the following formula as measure:

=Sum(Max([measurevalue] ForEach ([material];[Ordernumber];[Operation KEy])) ForEach ([material];[Ordernumber]))

The webi query will remain unchanged.

[Former Member · Accepted solution]

Perfect !!!!

Thanks for u r reply .:)