Hi all, i'm trying to find the minimum of a c...

Hi all, iโ€™m trying to find the minimum of a couple of columns of type โ€œpercentโ€ within a record but i get the error โ€œLIST has elements of mismatched typesโ€ This is the formula im using, all the fields being used are of type :โ€œpercentโ€

MIN({[Plan],[Connect & Create],[Align-Persuasive Sell],[Execute],[Evaluation (Call)],[Evaluation (Self)]})

Could i be doing something wrong?

0 3 317
3 REPLIES 3

Try MIN(LIST([Plan])+LIST([Connect & Create])+โ€ฆ

Or MIN(LIST([Plan], [Connect & Create], โ€ฆ ))

Awesome, thanks @praveen, @Bellave_Jayaram

Top Labels in this Space