I was thinking of that method. However, I want to be able to take the up to date forecast information and divide it by up to date actual sales to see how its doing.
Your Date>=Date(Datetrunc('month',TODAY())) and Your Date<=Today()
This would Restrict your data from August 1 to whatever is Today.
Drag it to Filter and Set TRUE , Then You can Create the above calculation you just said.