Forum Discussion
Minimum function is not giving the correct minimum value
Hello,
I have a column that ranges from 0.0003 to 51.3294. I want to get the minimum value in the column but it is giving me 1.0000, it should be 0.0003. The maximum is correct, 51.3294. Can you please assist?
Thank you,
Mildred
Hello ma142 , as you indicated in your last reply that you self solved your issue, would you please mark that reply as solved.
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you. Prpud to be a Super User!
2 Replies
I found out the issue, there is a value equal to 0 in the data. After I removed the 0, it gave the correct minimum.
Hello ma142 , as you indicated in your last reply that you self solved your issue, would you please mark that reply as solved.
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you. Prpud to be a Super User!
