Thanks, I did try to write out the nested if using some instruction from one of the devs. I'm new to this, as I typically create reporting in Crystal Reports. I looked over the code I wrote and found the error. Thanks for the reply.

I meant as on the dashboard itself, the chart I have presented will show "Data for 03/15/2016", since it ran this morning and is showing yesterday's data. But if it can be added somewhere so the end user knows this data is yesterday's data, that would be great.

Ebin, Thank you so much for this! I was overthinking my calculations so much. By using your solution it makes it so much easier. Cannot thank you enough.