Simple Music Royalty calculation help please

[johnppp]

Can you help please? I have a sales statement from itunes now in Filemaker. I have three different songs, SONGA, SONGB and SONGC. Each record has a field "Track Title" with one of the titles in it, and a "Net" field which has a numerical (cash) value. There are other fields which are not needed. I need a script to calculate each specific songs total added Net amount and display it after searching the 200 or so records. Any ideas musch appreciated or if anyone knows of a similar script I could look at that would be great.

[Lee Smith]

Hi John, and Welcome to the Forum

What version of FileMaker, Operating System, and Platform are you using.

You can enter this information in your Profile, and then you won't have to supply it each time you ask a question.

Go the the [color:red]Menu Bar, click on [color:blue]MY PROFILE >> Control Panel >> [color:orange]FileMaker Questions (bottom of the list)

Lee

[johnppp]

oops, thanks!

[johnppp]

this is a "basic" interpretation of what i need to happen, but i can't work this out as sadly i'm still a novice

let songacount = 0

let songbcount = 0

let songbcount = 0

loop

if tracktitle = "songa" then read field net

and add total net to songacount

if tracktitle = "songb" then read field net

and add total net to songbcount

if tracktitle = "songc" then read field net

and add total net to songccount

next record and repeat

end loop

display songacount

display songbcount

display songccount

[Fitch]

You've almost constructed a script there. (Hint: look into Set Variable.) But if all you need is to view the totals, a subsummary report would be less trouble IMO.

Or, you might want to keep your songs in one table and your sales in another. Then you could have a calculated field in songs that's simply Sum( related::net ).