Only 5 years after last post... Now using MC 26.
If I have an album with various artists, this code will calculate the album rating based on each individual artist on that album.
Let's say I have an album called "Weird". It has 2 songs from
Elvis and 2 songs from
Prince. I have rated the Elvis songs 5 and 4. I have rated the Prince songs 4 and 3.
What I will now have in the Album Rating column is:
- an album called "Weird" with an album rating of 4,50 (calculated from the Elvis songs)
- AND
- an album called "Weird" with an album rating of 3,50 (calculated from the Prince songs)
So that's issue number one.
Issue number two:
How would I modify the original "script" so that it would only count albums that have only one artist, BUT would also include those albums that have for example duets on them. This might for example be an Elvis album including a duet with Prince ("Elvis; Prince" in the artist column.)