Ah gotcha - I was doing a task report. Try this: displayname=Non-Overriden Revenuetextmode=truevalueexpression={owner}.{role}.{billingPerHour}*{hours}valueformat=currencyStringCurrency
Hey Nick, Would this work? displayname=Non-Overriden Revenuetextmode=truevalueexpression={role}.{billingPerHour}*DIV({workRequired},60)valueformat=currencyStringCurrency
Hi Jane, We don't use billing records so I don't have a good environment to test in, but could an hour report with this filter work? projectID=FIELD:billingRecordIDprojectID_Mod=cine Good luck!
Hey Samantha, I am striking out on this one. @Jason Webre‚ - reporting guru - any thoughts on this? Samantha is trying to create a Document Version report sorted by a project custom field. We were able to figure out the grouping, but not getting the sort. Thanks!
Hey Samantha, Can you login as another user and look to see if the sort is working? If it is, I ran into this problem before and I was only able to correct it by resetting the user settings on the person it wasn't working for (https://one.workfront.com/s/document-item?bundleId=workfront-classic&topi...
Hi Samantha, I do this to sort by a column that I don't want shown:Add the column that you want to sort by to your report and sort it by thatSwitch to text mode and find these three lines:querysort=<field>sortOrder=1sortType=ascCopy the three lines of text and remove the column from your reportGo to...