Custom hour report column using VALUEEXPRESSION

[NickVa1]

Hi WF Community,

Does anyone know how to capture the default role billing rate, using text mode and valueexpression, in order for me to create a custom calculated column to display a non-overridden revenue value (default role billing rate*hours)?

The standard Resource Revenue field in an Hour report uses either the role billing rate, or if overridden by a custom billing rate at the company or project level, it uses that. I want to create a custom revenue column that will always calculate based on the role's default billing rate, even if it's overridden by a company or project billing rate.

Here's what I have so far, but it's not working:

displayname=Non-Overriden Revenue

textmode=true

valueexpression={billingPerHour}*{hours}

valueformat=currencyStringCurrency

Thanks.

Nick

[SarahNa]

Hey Nick,

Would this work?

displayname=Non-Overriden Revenue

textmode=true

valueexpression={role}.{billingPerHour}*DIV({workRequired},60)

valueformat=currencyStringCurrency

[NickVa1]

Hey Sarah!

It looked promising, but doesn't seem to return any results :(

Thanks for the attempt.

[SarahNa]

What type of report are you using?

[NickVa1]

It's an Hours report

[SarahNa · Accepted solution]

Ah gotcha - I was doing a task report. Try this:

displayname=Non-Overriden Revenue

textmode=true

valueexpression={owner}.{role}.{billingPerHour}*{hours}

valueformat=currencyStringCurrency

[NickVa1]

Sarah, you did it! Nice work. I see the linking hierarchy you used. Perfect. Thanks.