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.
WeeklyTotal = Daily + Daily + Daily + Daily + Daily;
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.