Discussions

Expand all | Collapse all

Calculate a labor rate

  • 1.  Calculate a labor rate

     
    Posted 08-16-2017 17:39
    I am trying to calculate a labor rate from a field called wage that could either be an hourly rate or an annual rate. Here is what I have so far:

    If([Wage]>=$10,000.00, [Wage]/2080, [Wage])

    I am lost. thank you for any help.


  • 2.  RE: Calculate a labor rate

    Posted 08-16-2017 17:47
    close, just drop the $ sign


    If([Wage]>=10,000.00, [Wage]/2080, [Wage])


  • 3.  RE: Calculate a labor rate

     
    Posted 08-16-2017 17:57
    I ended up with this and it works. then just had to format the field as currency.

    If([Wage]>=10000, [Wage]/2080, [Wage])


  • 4.  RE: Calculate a labor rate

     
    Posted 08-16-2017 17:58
    it's always a small thing that I miss :)