I have a query that extracts actual and forecast income for stores from a table. I import the data from the query to my Excel dashboard and all works well.
I wanted to add a performance factor into the Access Query so added the calculation Perfomance: [Income]/[Forecast]. This works in the query and gives the correct values, but now, when I try to refresh my Excel dashboard, it will no longer refresh.
I checked it by trying to import the same query to a blank Excel sheet and got the same problem. Am I doing something wrong, or expecting something to work that simply won't? Thanks!