I am having trouble getting the sum of a column from my data table.
I have this table:
and I want the results to look like this:
I want to remove the multiple names and get the sum of the duration column for that specific name. My problem is I’m not sure of the syntax for getting the sum of DURATION/TIMESPAN. I tried converting into double as well but no luck.
Looking at the error message, it seem you’re using Assign activity to perform this operation.
Assign only allows a single expression that represents the right hand side of a variable assignment. (For instance, any number of method chaining is possible, but that’s about it)
You should use Invoke Code activity to perform the operations.
Pass the value in as argument of In/Out type so that your value is returned in the calling sequence for further use.
Hi, thanks for responding
The method I use works for int and double so I think it’s okay to use, my problem is when it receives a timespan/duration format like “6:00:00” it doesn’t work so I’m looking for a syntax that would work for getting the timespan/duration format