Help with Calculated Query. Error handling & Windowed functions cannot be used in the context of another windowed function or aggregate

Hi there,

I'm new to SQL server Express which I've been using for about a week and having fun writing some queries...but I'm stuck on a couple of things.

I’m running some calculations on 3 tables consisting of a date header, company hear and the 3^rd with my data.

The following calculation is working expect for when there’s a div/0 in a data set. How do I adjust so the query runs and say returns NULL when a div/0 event occurs.



E.g. 1



SELECT
Go to the complete details ...