I am looking to create a computed column for on the fly reporting. The query above only serves to show the output of what is needed, not how I will do it.

I was hoping to get help how to calculate the field.

Thanks