Forum Discussion

AnnS_'s avatar
AnnS_
Qrew Trainee
7 years ago

Calculate a labor rate

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.
Tables and fields

3 Replies

Sort By
  • AnnS_'s avatar
    AnnS_
    Qrew Trainee
    7 years ago
    I ended up with this and it works. then just had to format the field as currency.

    If([Wage]>=10000, [Wage]/2080, [Wage])
  • AnnS_'s avatar
    AnnS_
    Qrew Trainee
    7 years ago
    it's always a small thing that I miss :)