
1. Re: Calculate/Filter any customers that have X number of "points per day" with in a given day supply
Deepak Rai Sep 13, 2017 9:29 AM (in response to Ty Stackhouse)Please attach workbook.

2. Re: Calculate/Filter any customers that have X number of "points per day" with in a given day supply
Ty Stackhouse Sep 13, 2017 9:36 AM (in response to Deepak Rai)I guess that would help

Points and Day Supply.twbx 1.1 MB

Example Maxwell.PNG 15.6 KB

Example Karen.PNG 16.6 KB


3. Re: Calculate/Filter any customers that have X number of "points per day" with in a given day supply
Mia Lee Sep 13, 2017 1:20 PM (in response to Ty Stackhouse)Hi, Ty
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.
Thank you
Best,
Mia

4. Re: Calculate/Filter any customers that have X number of "points per day" with in a given day supply
Ty Stackhouse Sep 14, 2017 8:15 AM (in response to Mia Lee)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.

5. Re: Calculate/Filter any customers that have X number of "points per day" with in a given day supply
Mia Lee Sep 14, 2017 11:33 AM (in response to Ty Stackhouse)Hi, Ty
If you can't fix aggregate/nonaggregate on your own, try using a sample workbook that demonstrates all your troubles next time. Hope you find a clue from my suggestions, though.
Thank you.