Skip to main content

I am working on a report that should show our product broken down into 1 of 3 buckets which I have labeled as 'Forecast Class'. I have created an If / Elseif conditional statement but I can't seem to get it to work properly.  I suspect it's because of the order I have it broken down? But i've tried it other ways and still can't seem to get it.

 

I'm including a picture which will show what my calculation is currently and the rules for the forecast class bucket.

 

Any help is greatly appreciated!

1 answer
  1. Jul 26, 2021, 3:03 PM

    @Amanda O'Neill​ you need to replace "or" with "and" otherwise most of the cases >2800 will be B.

    thanks,

    Adrian

0/9000