@pietlinden

I am not sure I understand.

I basically need

select *,

case when 'Issue' IN ('Overforecasted', 'Underforecasted') AND 'Start Date' DISTINCT 3 dates THEN 'Issue exists for 3 weeks in a...

@pietlinden I am not sure how I can provide scripts... I have no idea what is this tbh...

I have similar to what Steve Collins have described. It runs...

• This reply was modified 2 years, 2 months ago by  JeremyU.

Steve Collins  I am not sure I understand what I need to do. In my last post I have provided the minimal code  that you suggested to provide. I cannot...

• This reply was modified 2 years, 10 months ago by  JeremyU.
• This reply was modified 2 years, 10 months ago by  JeremyU.

@steve-2 Collins

I am really sorry I am not that experienced may not understand some things.

This is the minimal code (I trimmed it down as much as I could).

I...

• This reply was modified 2 years, 10 months ago by  JeremyU.
• This reply was modified 2 years, 2 months ago by  JeremyU.
• This reply was modified 2 years, 2 months ago by  JeremyU.

When I add the code, I start getting errors.

• This reply was modified 2 years, 2 months ago by  JeremyU.

@steve-2 Collins thank you for your response. It should be one of 3:

• This reply was modified 2 years, 2 months ago by  JeremyU.

@steve-2 Collins thank you very much for your reply. It is very helpful.

I have a question what the code shows.

So do I understand correctly the code finds all...

• This reply was modified 2 years, 2 months ago by  JeremyU.

@steve-2 Collins thank you very much for your reply. It is very helpful.

• This reply was modified 2 years, 2 months ago by  JeremyU.

@steve-2 Collins thank you very much for your reply. It is very helpful.

• This reply was modified 2 years, 2 months ago by  JeremyU.
• This reply was modified 2 years, 2 months ago by  JeremyU.

@pietlinden thank you!!

@pietlinden I figured how to fix it in SQL. I removed store numbers, grouped on forecast (but didn't sum) and summed on hand and on order. As a...

@mmartin1

In the forecast table FCSTPERFSTATIC [LOC column] table is basically chain names and we don't forecast at a store level. I join this [LOC] (Chain name) to another...

Ohh I figured that, my apology, i will appreciate if it can get removed.

Phil Parkin when I remove the grouping I have the very same numbers, just not grouped, but when I copy and paste them in Excel and calculate the numbers they...

@pietlinden

I am not sure I understand. I don't have any CREATE TABLE and INSERT scripts. The whole code that I had I wrote over here. I don't have...