Custom hour report column using VALUEEXPRESSION | Community
Skip to main content
NickVa7
Level 9
Dec 2, 2020 8:32 PM UTC
Solved

Custom hour report column using VALUEEXPRESSION

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.
    SarahNaAccepted solution
    Level 6
    Dec 4, 2020 6:18 PM UTC

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

    displayname=Non-Overriden Revenue

    textmode=true

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

    valueformat=currencyStringCurrency

    View reply

    6 replies

    NickVa7Author
    Level 9
    Dec 4, 2020 7:40 PM UTC

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

    Translate
      NickVa7Author
      Level 9
      Dec 4, 2020 5:43 PM UTC

      It's an Hours report

      Translate
      SarahNaAccepted solution
      Level 6
      Dec 4, 2020 6:18 PM UTC

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

      displayname=Non-Overriden Revenue

      textmode=true

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

      valueformat=currencyStringCurrency

      Translate
      SarahNa
      Level 6
      Dec 4, 2020 4:51 PM UTC

      What type of report are you using?

      Translate
      NickVa7Author
      Level 9
      Dec 4, 2020 4:43 PM UTC

      Hey Sarah!

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

      Thanks for the attempt.

      Translate
      SarahNa
      Level 6
      Dec 3, 2020 2:47 PM UTC

      Hey Nick,

      Would this work?

      displayname=Non-Overriden Revenue

      textmode=true

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

      valueformat=currencyStringCurrency

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...