I’m creating an app that will help artists and musicians with their royalties. It involves some pretty heavy calculations to make it work (which I’m fine with), but I need to make a sum calculation on a collection of a few of the artists on the database - but not the whole database - and I can’t seem to do this? Please help!
For simplicity whilst I build a test/development app, I have a test database of just 20 example artists for now, below left, arranged descending with artists with the highest score at the top.
I can return individual scores for any artist, (item#, or first/last/random item, etc) but what I can’t find a way to do is to return the sum of, say, the 2nd through to the 5th artist?
How can I create a :sum on the 2nd, 3rd, 4th and 5th artist scores?
Thanks for any help