Perfect, thank you.

Thank you both for the quick response. I'll give each a try.

A previous developer had all the calculations in the code section of the SSRS report but it no longer works. I'll try re-writing the query with your suggestion.

Thank you!