Please attach workbook.
Please find the attached workbook.
I have created 2 calculated fields and a parameter (date to use for a reference date) - this can be changed later for any reference date you'd like on your workbook (even a calc field, today() if you want to use today's date as a reference date)
Basically I calculated Shipdate+DateSupply date- to compare to reference date to figure out when the point expires, (DATE(dateadd('day',[Day Supply],[Ship Date])))
and Points Per Day to be zero when reference date is passed the Shipdate+datesupply. (IIF([RefDate]<=[Shipdate+DaySupply_Mia],[Points per Day],0))
Hope this helped.
Mia Lee Thank you for the response!
Unfortunately, I was unable to do a comparable replication of "Points per Day_Mia". In my workbook my "Points per Day" field is calculated by two other fields, one of the other fields coming from another data source. In order to bring these together they must be aggregated. Therefore, when I try to calculate "Points Per Day_Mia" I am met with a "cannot mix aggregate and non aggregate arguments with this function" error.
Thank you for your insight into my issue I will try to find a work around for this problem.
If you can't fix aggregate/non-aggregate on your own, try using a sample workbook that demonstrates all your troubles next time. Hope you find a clue from my suggestions, though.