Hello Experts
I want to implement Excel Formula Fuction that is Minimum from a set of columns. When I implement another formula such as SUM or AVERAGE, that’s works perfectly. But if i change the formula to MIN or MAX, it won’t show any result. Here are some pics to be clear. Appreciate for your guidance!
SUM formula works fine:
While MIN formula isn’t showing anything :
I never use the Excel column, but I can suggest a workaround.
Use a Make Array column to create an array from the 3 columns, then target that with a Rollup->Minimum.
Thank you, Darren for your suggestion. That’s work!
And not all Excel formula works in Excel Formula column that Glide provide.
Now I can move on. Thanks a lot!
Darren, one more issue about the RollUp.
I think one of my column not detecting the number, so that Minimum function is not showing up.
I assume that because the text: 15 10 12 that I split from a Choice, is not recognized as a number. So I tried to convert it as a number with simple Math column, then Make Array, and RollUp. But the Minimum function still doesn’t work.
I need your enlightment once again. Thank you.
You could just use a math column for all of this and skip creating the array.
For Min, you could do something like this.
min(min(x,y),z)
Oh Jeff, I’ve tried it at the Math Column. And that’s works with the Minimum fuction. Thanks!
Hehe that’s smart 
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
