-
Storing Projected Values
I have a graph setup giving me daily data. (e.g. sales). I've used as part of the graph "Multi-Period Projection" and set it for 5 days out. What I want to know is how accurate this is to the actual. Today is 1/31/2023 and sales was $1M, and the prejection for 2/3/2024 is $1.3M, I want to know how close the projection was…
-
Use of Pivot Table When a Column Contains Many Variables
You may have run accross this when dealing with FedEx or UPS parcel data. An invoice can have 100's of packages, and for each package you can have many individual charges - e.g. charge, discount (negative), fuel, residential, over dimension, etc. There are many of these, and they are adding to them all the time. I want to…
-
End of query request - what is wrong
I continue to get an end of query request and not sure what I'm doing wrong. Please help me understand what I'm missing. I have tried adding and adjusting - just not working. Below is the query. SELECT * FROM CHARGE_DETAIL WHERE INVOICE_NUMBER = 217653436, 217668183, 819802440, 820092602, END
