This content has been marked as final. Show 5 replies
I am trying to use a WHERE clause with an AND clause to achieve the following:
Actual Volume should only be loaded if >= 0.
No data should be loaded if Forecast and Actual both = 0.
I have tried the following but it seems to eliminate records where Forecast = 0 but Actual does not.
WHERE [Actual Volume] >='0' AND ([Actual Volume] <> '0' AND [Forecast Volume]<> '0');
I'm not sure if I'm perhaps using AND incorrectly or misplacing my ().
Thanks for your help!