AnsweredAssumed Answered

How to find a field based on a calculation on another field.

Question asked by aiharris on Aug 13, 2018
Latest reply on Aug 16, 2018 by philmodjunk

In several of my DBs, I have the same issue. One field is a date, the other is a variable such as range of motion of a knee, patient weight, or it could be stock prices. It is easy to define a global variable that is the maximum or minimum of the variable that is not the date.

 

How could I create another calculated value that represents the date of the Lowest Stock price, Highest stock price etc. In the case of the range of motion of a knee, I'd also need to be able to sort for the first date with the maximum ROM.

 

Seems that this should be easy, but so far, I'm striking out.

 

Thanks in advance.

Outcomes