Invalid Operation for simple formula

Andrea Zenner

I have this formula that is returning INVALID OPERATION

=IF({AMR Location} = "Baltimore Mfg", AVG({AMR Level}), "")

The Location column is just text. The AMR Level is a number that is calculated from a pick list column.

=IF([Level of Professionalism]@row = "1", 1, IF([Level of Professionalism]@row = "2", 2, IF([Level of Professionalism]@row = "3", 3, IF([Level of Professionalism]@row = "4", 4, IF([Level of Professionalism]@row = "5", 5, 0)))))

I can successfully do an average on the whole Level column so I know it's converting to a number correctly.

Why am I getting the error when I try to do an average by location?

Thanks!

Andrea

Eric Law

Hello @Andrea Zenner,

Have you tried using COLLECT? Try using the following,

=AVG(COLLECT({AMR Level}, {AMR Location}, ="Baltimore Mfg"))

Eric Law

Hello @Andrea Zenner,

Have you tried using COLLECT? Try using the following,

=AVG(COLLECT({AMR Level}, {AMR Location}, ="Baltimore Mfg"))

Andrea Zenner

That worked! Thanks much! I haven't used COLLECT before. Learned something new today. 😊