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