Query Field Not Available on Dashboard (but is available?)

Epicor ERP 10
1

I’m working on a dashboard that is comparing our current available labor vs. what would be ideal for our schedule in order to determine where we need to concentrate on hiring and training to improve our productivity.

I have some queries that pull in the information needed for the dashboard and the queries work fine. However, when I pull the one into the dashboard, it has some unusual behavior.

image
image640×633 14.3 KB

While the Total Needed Hours field shows on the dashboard, it does not show in the dashboard grid properties. The biggest issue comes with the moment I change the caption for this section, it pushes the column which does and does not exist out to the end which screws up the order:

image
image637×620 16 KB

The column is still listed in the filter section of the dashboard grid properties (it is Calculated_TotalHours01):

image

Anyone have any idea how, why, or what is causing this column to not be available in the Dashboard Grid Properties? I tried just deleting the dashboard and starting over, but same results. I have not yet deleted the query and rewrote it, but that will be next if no one has any ideas. Thanks in advance.

2

I opened the query on one screen and on the other created another one that was an exact duplicate of the other (typed it, did not use the copy command). Added the new query and it worked fine. The only difference between the two queries is the order of the subqueries and top query. Broken one top query is number two. New one it is number one. Don’t think that should cause this, but that’s the only difference between them.