Expand my Community achievements bar.

SOLVED

How to aggregate hour and cost rates by task

Avatar

Level 10

Hi Fusion community,

 

We can't use the native user or job role cost rate fields, so we went ahead and created a custom field on the user object to store, and hide, cost rates for each user.

 

I want to use Fusion to calculate a task's sum cost based on all of the hour entries against it and users cost rates.  We have multiple users logging hours to a task.  Each user has a different cost rate.  I've gotten as far as calculating the sum cost, per users on a task, but I'm having trouble figuring out how to aggreate these values into one Task Cost value.

 

Here's what I have:

Screenshot 2024-01-15 at 3.23.28 PM.png

 

Screenshot 2024-01-15 at 3.23.10 PM.png

 

I'm getting the correct CostbyUser for the task, but I'm wondering if setting this up as a variable might not be the way to go about it in order to them aggregate all of the CostbyUser values?

Thanks!
Nick

 

1 Accepted Solution

Avatar

Correct answer by
Level 10

Ok, I figured this out with some tinkering


For anyone who potentially runs into this in the future, see below screenshot for how I set this up properly.

 

Screenshot 2024-01-16 at 12.47.10 PM.png

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Ok, I figured this out with some tinkering


For anyone who potentially runs into this in the future, see below screenshot for how I set this up properly.

 

Screenshot 2024-01-16 at 12.47.10 PM.png