So far i have come up with this(Gives me a rating from 1-10):
FormatNumber(math(If(IsRange([Number Plays],0-7),[Number Plays],8)+math(IsEqual(ConvertDate([Last Played]),math(Now()-180),5)*.5)+math(IsEqual(ConvertDate([Last Played]),math(Now()-365),5)*.25)+math(IsEqual(ConvertDate([Last Played]),math(Now()-90),5)*.25)+math(IsEqual(ConvertDate([Date Created]),math(Now()-180),5)*.25)+math(IsEqual(ConvertDate([Date Created]),math(Now()-365),5)*.25)+math(IsEqual(ConvertDate([Date Created]),math(Now()-90),5)*.5)+IsEqual([Number Plays],75,5)),0)
Quick explanation if you don't feel like tearing this apart:
+First section gives the song a starting rating based on play count from 1-7 anything higher gets an 8.
+Second gives it a 1/2 point if it was played in last six months
+Third gives it a 1/4 point if it was played in the last year
+Fourth gives is a 1/4 point if it was played in the last three months (1 total point possible depending on last played date)
+Fifth gives a full point if song was played over 75 times
This gets me kind of close to what i want to accomplish. Pretty bottom heavy but I've changed how i rate things now. The only thing that is hanging me up... I want to include one more way to get points that I can't get to work:
math([Number Plays]/(FormatNumber(now()-ConvertDate([Date Created]))))
I can only get this to return 0. I can times (*) number of plays and the date calculation but once I try to divide it won't return anything?? Any clue what may be going wrong?