Custom hour report column using VALUEEXPRESSION | Community

Level 9

Solved

Custom hour report column using VALUEEXPRESSION

Forum|Forum|5 years ago
December 2, 2020
5 replies
924 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by SarahNa

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

displayname=Non-Overriden Revenue

textmode=true

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

valueformat=currencyStringCurrency

Level 6

Hey Nick,

Would this work?

displayname=Non-Overriden Revenue

textmode=true

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

valueformat=currencyStringCurrency

Level 9

Hey Sarah!

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

Thanks for the attempt.

Level 6

What type of report are you using?

Level 9

It's an Hours report

SarahNaAccepted solution

Level 6

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

displayname=Non-Overriden Revenue

textmode=true

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

valueformat=currencyStringCurrency

Level 9

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