Issue with Calculating Averages from Linked Cells in Reports

Möller

I'm experiencing an issue with calculating averages in a Smartsheet report. The cells in my source sheet are linked from another sheet, and when I try to use the AVERAGE function in the report, the result shows as "NaN". It seems that Smartsheet might not be recognizing the linked values correctly. Is there a way to calculate averages from linked cells in reports, or is there a workaround for this issue?

Thank you for your support!

Paul Newcome

How is the source data populated?

Möller

The data is copied from a CSV file into a normal Sheet and then transformed into percentage values in new cells.

Paul Newcome

How is it transformed? Are you using a formula? If so, what is the formula?