Summing in IEE lobby, when no data why X displayed

Hi @LMWCBACH 

many problems cause this error.

Could you at first post a screenshot of your data source?

Does it work?

If you know the data is correct, you could try nvl e.g.

SUM(NVL(PLAN_LABOR_RUN_TIME,0))

Hypervox - that does not work, it will not even run the sum for that when I put in the NVL on it. The box does not refresh itself like all the others it just stays as a X. 

Link Hero - the screen does work. Here is a shot of one that does have data that fits into the criteria

When there are not current closed shop orders (for the day) for a specific site we get the following-

Sorry my mistake - does nvl(sum(plan_labor_time),0) work?

Hypervox - that one does not work either. nvl(sum(plan_labor_time),0)  or SUM(NVL(PLAN_LABOR_RUN_TIME,0)) it will not run the sum. 

Interesting.  I thought maybe that I’d got the format of the NVL wrong, but there is a Data Source in IFS that uses that expression - “FI Balance Analysis - Write Off” that is the same format.

Can you give details of your datasource?

Here is what we are trying to display, but because there are no closed Shop Order Operations yet for today it has no records getting pulled

If I was doing a count it would display a zero, but I think because I am doing a sum and there are no records that meet the criteria it cannot display anything.

If I hover over the element this gets displayed.

I’m on IFS9, and I don’t have all the same columns you have.  However, I can get the sum to work as you’d expect (this is on my test system which has got old data so no records exist for the current day)…

I think the next step would be to take the SQL into SQL Developer and run it there - see if you get the results you’d expect.

Hi, the problem is the GROUP BY value you have added. If the condition is not met and no records found this SQL will not return a row.

You could create a data source without the group by for the counters.