I have a report which calculates Mean, Median and Averages.
Median calculation is a bit complex for which I'm using code (script). I'm not able to export this field. All that shows up in the exported excel file is #VALUE!
Any chance that it's just a formatting issue? Make certain the datatype is set to the correct format and such (fixes numbers stored as text issues)? Also that the column is wide enough to hold the data when it is exported to excel.
-Luke.
To help us help you read this[/url]For better help with performance problems please read this[/url]