Weekly and Monthly Totals

[cjkitz]

Hi,

I want to come up with a loop to add values for weekly and monthly totals to display in a dashboard. Currently I do it the very basic and sloppy way of writing out the full equation for each total.

For example:
WeeklyTotal = Daily[0] + Daily[1] + Daily[2] + Daily[3] + Daily[4];

Obviously this gets worse when I deal with a whole month's worth of data!

This should be simple but I cannot get any loop I try to work. It doesn't help that I am using SharePoint Developer to do my coding as it provides little to no error notifications!

Any advice would be greatly appreciated.

Kind Regards,
CJ.

[KenaG]

for (i=0;i<Daily.length;i++){
WeeklyTotal += Daily[i];
}