spamcatcher
Technical User
Hi All,
Im trying to create a very simple list using custom content types to track employee time off requests. I created 2 content types "add earned comp time" and "use earned comp time". Created a custom datasheet view that sums up all of the hour values for additions/subtractions to comp time.
EG:
Sum=3.5 Sum=3.0
Add Time Use Time
1.0
2.5 1.0
2.0
As far as i can tell (and have researched) sharepoint (out of the box) is unable to do math using a value from a calculated column, and can not make references to the Sum= (value) fields generated in the custom view.
So... How do i get sharepoint do give me a running total on the two columns? Eg: I would like to display that there is an outstanding balance of .5 hours in my above example. Cant believe it should be this hard to do something so innately simple!?!
Have seen a few examples using javascript, I dont have the permissions/know how to use them in a reasonable amount of time.
Thanks in advance for any assistance!
Im trying to create a very simple list using custom content types to track employee time off requests. I created 2 content types "add earned comp time" and "use earned comp time". Created a custom datasheet view that sums up all of the hour values for additions/subtractions to comp time.
EG:
Sum=3.5 Sum=3.0
Add Time Use Time
1.0
2.5 1.0
2.0
As far as i can tell (and have researched) sharepoint (out of the box) is unable to do math using a value from a calculated column, and can not make references to the Sum= (value) fields generated in the custom view.
So... How do i get sharepoint do give me a running total on the two columns? Eg: I would like to display that there is an outstanding balance of .5 hours in my above example. Cant believe it should be this hard to do something so innately simple!?!
Have seen a few examples using javascript, I dont have the permissions/know how to use them in a reasonable amount of time.
Thanks in advance for any assistance!