Skip to Content
0
Jan 25, 2023 at 08:38 PM

Get average from column if values are numeric

47 Views

Hello,

I'm building a report currently that has dynamic column types. Sometimes the values will be numeric and sometimes they will be alphanumeric.
At the bottom of the report I have averages for the columns but am running into issues with getting the average of a string type.

I'm trying to write my formulas in a way that if any of the values are alphanumeric then don't display any average at the bottom but if all of the values are numeric, convert them to a number, and then get the average. I've been unable to get this to work though.

Any tips or information on how I can do this?
I need a formula that will loop through the records (to check if they are numeric and sum so I can average) but based on my research it doesn't look like I can do this.

Thanks.
--Brandon