So I have a Total Field that on the calculate event i
have:Sum(Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday)However
when i add your if statement:if (Activity == "Holiday")then
Holiday.rawValue =
Sum(Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday) else
Holiday.rawValue = 0endifThe total field no longer totals anything
UNLESS I choose holiday for the Activity field.... Any idea why that is?