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