Calculate Maximum Value for a Parameter in a Schedule and Use in Calculated Parameter

[tim102289]

Is it possible to calculate the maximum value in a column (maximum value for one parameter in the schedule), and then use that maximum value in another column (new calculated parameter) to calculate something else?  I found a workaround for calculating the sum of values in a column, and then using that in a calculation, (by calculating percentage, and then dividing the value by the percentage to get the total) but can't think of a similar way to do it with maximum.

I am working with a Space Schedule, trying to calculate the maximum value (worst case) for something, and then use that maximum to calculate something different.

[iainsavage]

Possibly a task for Dynamo?

[robert2JCCH]

Through the Revit UI? Probably not, pushing total sum into a calculated parameter via inverting the % of total is already more or less a magic trick (which doesn't work if any of the values are 0, fun!). 

This leaves live automation through a third party add-in, or applied automation via something like a Dynamo script (execute script to update the parameter).

[fabiosato]

Hello,

In the schedules, you can choose maximum and minimum in the calculation setting, but you can't use them in a formula.