Macro Max of another macro column

[Redhead77]

I need a macro to get the maximum value of another macro in my report. Have tried a macro that gives me the sum of another macro field, need one that is similar to that to get the max. Any ideas?

 

[dlblack]

I would try modifying the sum macro to include an "IF condition THEN action [ELSE Alternative_Action]", so that when you are stepping through the records if the value of the next macro derived field is greater than the current value, set the new derived field to the greater value.

Just a thought.

David L. Black Consulting