Text Mode: Billing Rate

[KateEl1]

Hi, Can anyone help me create a column on an hours report that is the billing rate? I know I'll need to do Actual Revenue / Hours, but I don't know how to translate it into a calculated column on a report. Thanks! Kate Elliott Precision Dialogue Marketing, LLC

[AdinaPi1]

Hi Kate, this is the text mode I have on a column on my Hours tab:

valueformat=currencyStringCurrencyRounded

querysort=resourceRevenue

textmode=true

linkedname=direct

namekey=resourceRevenue

valueexpression=DIV({resourceRevenue},{hours})

displayname=Hourly Rate

[KateEl1]

Thank you! Kate Elliott Precision Dialogue Marketing, LLC

[pco88]

If you are looking for Actual Revenue / Hours

displayname=Your Rate

namekey=hour.plural

querysort=hours

textmode=true

valueexpression=DIV({project}.{actualRevenue},{hours})

valueformat=currencyStringCurrencyRounded

Cheers.

[DagmaraGa]

Have you got billing rate assign to every user?

Try this one:

displayname=Billing Rate

linkedname=owner

namekey=view.relatedcolumn

namekeyargkey.0=owner

namekeyargkey.1=billingPerHour

querysort=owner:billingPerHour

valuefield=owner:billingPerHour

valueformat=currencyStringCurrencyRounded

[tracy_fox]

Good morning all, Jumping on this older thread to ask the experts about Company Billing Rates. Is the only way to display Company Billing Rate is by using a calculated column in a report? Thanks! Tracy Fox Project Manager / Workfront SysAdmin Sykes Assistance Services Corporation

[DagmaraGa]

On an Hour Report you can pull the field which shows that info about hour's owner or a job role assigned to the owner - whichever you use in your company.