BusinessObjects Board

how to Get Max value

building reports webintelligence
#1

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

[/code]

sunil kumar :india: (BOB member since 2011-10-03)

#2

Moderator note:
Please help keep BOB friendly! Review this topic for some suggestions, thanks.

If you indeed have such an urgent issue either contact SAP tech support or consider hiring an experienced consultant. Thanks.

Andreas :de: (BOB member since 2002-06-20)

#3

Hi Sunil,

Use following formula
=Max([measure]) In([ordernumber])In Body and let me know the result

babu_272 :india: (BOB member since 2010-07-28)

#4

Try this.

var1 =Max([measurevalue]) In ([Ordernumber]) - To get max value for each order number

var2 =If((Previous([var1])<>[var1]);[var1]) - To remove duplicates

var3 =RunningSum([var2]) Where ([material]=“aaa”) - To sum up the max values.

Finally, do apply format options in var3 to display only one value for each material.

Hope this helps.

BOBJ Consultant (BOB member since 2012-02-16)