Solved
Formula to calculate hours
Please help write a formula to take estimated hours time different frequencies (daily, weekly, monthly) and calculate monthly hours. I currently have box for estimated hours, and radio buttons for d...
There is more than one way to write this formula, but probably the most concise way of doing it is using the Case function. That is because we are going to repeatedly be checking the same field to see what the value is.
Case([Frequency],
"Daily", [Estimated Hours] * 20,
"Weekly", [Estimated Hours] * 4.33,
"Monthly", [Estimated Hours],
"Quarterly", [Estimated Hours] / 3
"Annually", [Estimated Hours] / 12)
