Adding Numbers Together

Help & Questions
1

I am trying to get the number of hours worked for a ticket. I could not find an equivalent to billable hours in the API ( If you know of one, please tell me), so I am looping through the TimeEntrys. How do I add numbers together? If I can, I can sum up all the hours worked and get a total. - thanks

2

Hi @KeithTessler ,

Thanks for asking.

There is currently no process by which you can do math in MSPintegrations workflows.

BUT, it is a common request, and we do plan to visit this after our upcoming release. I’ll be sure we notify you if this becomes an option in the future.

Thanks!

1 Like
3

Hi Travis

Is there any further news of this feature being added to Email2AT ?

Thank you

Richard

4

+1 for me on this… would be great to do some basic Math within MSPIntegrations

5

Admittedly it’s a little hacky but is tested and working with the only Addition and Subtraction functions available to us, Dates.

First render a custom.ZeroValue as {{date “0000-01-01 00:00:00”}}
Yes a year of 0000 does work, and we will use the years portion of the date as our numerical value.

To add a number, render custom.NumberDate as “custom.BilledHours years”, and then add them together with another render of {{date custom.ZeroValue add=custom.NumberDate}} saving the output to custom.RunningTotal. Repeat for as many numbers as you want to add, assumedly in an Iterate step.
To compare the RunningTotal to another value, simply render that as a date in the same way {{date custom.ZeroValue add=custom.CompareValue}} and use the Boolean expression builder conditions to compare the RunningTotal and CompareValue.

Or render the numerical result (assuming the total is less than 10k, with {{date custom.RunningTotal to_format=“Y”}}.
If your totals will be larger than 10k and you only need them for comparison conditions, use seconds instead.

image
The variable names are different in my test, but I’m sure you get the idea.

6

@Mark

This is genius. I’ve never considered using the date helper to do math. Thanks for sharing!!

7

Wow, thank you so much for thinking of this. I will see if I can get it to work.!!!