Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
RangeMax(
Sum( {<BMIYEAR={"$(YearNo1)"},BMIWEEKNR={"<=10"}>} BRT)
,Sum( {<BMIYEAR={"$(YearNo2"},BMIWEEKNR={"<=10"}>} BRT )
)
-Rob