Finding Max Value within a Table

[#1]

Hey, I have an expression in a table that calulate the slope of two points for a line graph. What I would like to do is just show the maxium slope or slopes in the table. This is the code I have:

=
(Count({<Dateentered={'$(EndCompareDate)'} >} Model) - Count({<Dateentered={'$(StartCompareDate)'}>} Model) )
 /
(num(Left(EndCompareDate,2)) - num(Left(StartCompareDate, 2)))

I tried using Max() and RangeMax() but neither of these worked. Any ideas?

[johnw]

I'd have to see both your table and how you want to view this to say for sure, but I think you want something along these lines:

=max(aggr(your expression,your table dimensions with commas between them))