Maximum Calculated Fields

[#1]

Hello,

I have two calculated fields:

=Sum( {<BMIYEAR={"$(YearNo1)"},BMIWEEKNR={"<=10"}>} BRT)

=Sum( {<BMIYEAR={"$(YearNo2"},BMIWEEKNR={"<=10"}>} BRT )

Now i want to have the maximum value of both.

How do i do this?

[hcabrera]

Hi Ama,

I do not know if it is as optimal but you can use a pivot table an expression to compare the two calculated fields and determine the largest in the pivot table can be used also as expressions calculated fields.

Saludos,

Henry C.

[rwunderlich]

RangeMax(

Sum( {<BMIYEAR={"$(YearNo1)"},BMIWEEKNR={"<=10"}>} BRT)

,Sum( {<BMIYEAR={"$(YearNo2"},BMIWEEKNR={"<=10"}>} BRT )

)

-Rob