Hey sorry I haven't touched this in awhile.I have an expense report and a dropdown for category. I need to then sum the expenses based on that dropdown.Something like:If ExpenseDesction[n] ="abc" or "bca" or "cba" thensum ExpenseAmount(n)Else sum ExpenseAmount(n)Seems super simple.

Yes. There is the "Total" field which gets the $=0 but I added "holiday" to total just holiday hours. So I took your formula and added a bunch elseif statements. I can post my final formula later as now I am out of the office. Best Regards,Benjamin Speich Customer Service SpecialistMentice Inc.Cell ...

Oh sorry yes. I guess i need to go get lunch. I have a "Total" column and then a a break out section of what the the hours are as monday can have 3 hours of Vacation and 5 hours of regular, so i just had to tweak the if statement and yes replace the $=0 with what i wanted.

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          Ho...

Thanks for your patience. Working pretty good now.

So i switched to FormCalc and got this to workfor I=0 upto Activity.nodes.length - 1 step 2 doif (Activity[I] eq "Holiday") thenHolidayHours.rawValue = Monday[I] + Tuesday[I] etc...endifendforProbelm is I can't figure out in what even to place it so it is updated everytime the user edits any of the ...

The script is on the Calcuate event of the the "total" field so as the add hours on differnet days the total will change.So what i am trying to do is run through the different activity fields and find with column is "Holiday" if it happens to be Activity[5].rawValue = "Holiday" then I want the total...

So I have a table set up and need to add up the hours for specific activities.I have Activity() as an array of drop down boxes with things like "holiday, regular, vacation, etc"Monday(), Tuesday() etc, are numeric field arrays.and i am trying to popluation totals from the differnet Activities.Using ...

This is definately a big help and on the right track. However I am having issues with the focus. If i choose NOT a monday i get stuck in a sort of loop with the message.I will keep trying to fix this, but my other option would be to create a dropdown box that is populated by all mondays for the curr...

So I haven't touched Adobe or Java in over a year and am having trouble remembering a few things.I have a weekly timesheet I am editing and am having some issues.1. The User is to select the start date first, however i only want this to be a monday.2. This date will then populate the columns with th...