Ok, I will try that. Thanks for your help! 🙂

I think this may work, but I am still a little confused. So in my 1st dataset I am going to put....

SELECT CLM_DOUT

FROM ...

Yeah What I did was I created 3 data sets. One for each of those formulas for Weekly,Monthly and Yearly.

Then this is my Sql below.

SELECT DISTINCT

...