Burn Rate Custom Field RRS feed

  • Question

  • I am trying to add a custom field that calculates the burn rate of a task (actual cost / actual work) in order to see that average cost of work actually performed by various staff on that task. The result is being shown as a decimal number instead of dollar amount ($/hr). Any suggestions to format this formula would be appreciated. 
    Monday, June 15, 2020 2:46 PM

All replies

  • Par904,

    It sounds like you customized a number field or perhaps a cost field but in order to get the type of format you want you'll need to customize a text field such as:

    Text1=format([Actual Cost]/[Actual Work]*60,"$0.00") & "/hr"

    Hope this helps.


    Monday, June 15, 2020 4:06 PM