Hello,

There is a ShiftSchedule Information Register and it have Shift and Cashier.I want to show Cashier and Total Hours but Hour is not available in Information Register.How can I do this.

To clear understand , I have added some picture.

Attached Files

Download MyReport.PNG (3.6 KB)

Download TrueReport.PNG (3.45 KB)

Download MyQuery.PNG (5.12 KB)

Hi Mesut,

What module and what task is this?

6.Module and 2.Task

Hi Mesut,

The Shift dimension of the ShiftSchedule information register is a reference to the Shifts catalog. This catalog contains Start and Finish attributes. These attributes show when each shift starts and finishes. The finish time minus the start time gives you the duration of the shift.

I have used DATEDIFF function and the problem has solved.Thank you very much!

I have solved the Task4 in 5.Module.It looks like true but system says it not completed.I didn't use Having,maybe it is the problem.I didn't understand why must I use "having".

Hi Mesut,

Your solution is clearly incorrect. For example, when you set the "Total is greater then" to 0, the total for Beef Ribs is 135. But when you set it to 100, the total for the same product is 120. This filter setting has to filter out some rows from the output. Instead, it changes the result of the SUM calculation.

Looks like you don't really get the difference between WHERE and HAVING clauses.

Please, re-watch this and this episodes of the course once again.

Yes, I have solved the problem.And then

It shows fraction but If a number have not fraction , it doesn't write zero fraction.
I tried hard but not solved.

Attached Files

Download screen.PNG (6.72 KB)

Download dynamicList.PNG (18.44 KB)

Mesut, this task does not ask you to use the CAST function. By using CAST you decreased the precision of your query output and get the wrong result. Just get rid of all CAST functions in the query text, and it should start working.

It works,thank you very much!