Sum Amount of Persons

[freecolours]

This problem is a bit tricky and I can't figure it out myself.... ... anybody....?

I need to sum up the total amount of estemated persons in a certain period of days.

This is the situation:

- for every day of the week there is a calc field (MonNr, TueNr, WedNr, ThurNr, FriNr, SatNr, SunNr) that will show the amount of people for each day.

- there's a global 'start' datefield and a global 'end' datefield (a 'DayNr' calcfield will show the amount of days from the start to the end date).

What I need to know is:

- the total amount of people -in one calcfield- when the 'DayNr' > 1 or even > 7 (the calculation needs to sum up more then 1 -for example- monday)

[freecolours]

Figured it out! This is what I did:

- Made a script called "Count persons" and set all the daynumbers with a loopfunction in a text global '_gDays'. (_gDays & DayofWeek(_gTempDate03) & "