I think it's safe to hard-code the 24 hours/day into your calculations. That's not changing anytime soon. ;-)
Can you join the values to your main data source on Process, or do you need the multiple different Process values available to your calculations?
if that's the case, try pivoting the values for your constants so that, instead of rows, they appear in columns (Column A, B, C, etc., just like in Excel).
The resulting table would be 1 row long, and you would join to your main data set on a 1=1 join. Then each row will have access to all the constant values.
Though this seems like it's redundant (putting every value on every line), Tableau is efficient and there shouldn't be a big performance or space impact.
It's quite difficult to understand your issue without seeing the data.
Could you attach sample sample data and expected result as illustration.
Sorry to both of you who responded, I didn't get back right away because I was off for a few days.
Thank you Branden, that is a great idea. I'm also corresponding with my Tab Server Admin about how to handle this too. But I think that your idea is perfect for proof of concept.
Shin, I'll try to mock something up.