What I want to happen is something like:
โEnum column = Regular time Rate then use [Regular Time Rate]X[Number Of hours] or if Enum column = Over Time Rate then use [Over Time Rate]X[Number Of hours]โ
for some reason this forum isnโt showing the * symbol in the expression above so it has been replaced with X
Some background information:
I have two tables,
One is Position
The other is Timesheet
The position table stores what the Regular Time rate is in one column and the overtime rate is in another column.
I then have a column in the timesheet table that has Total wages.
Enum column has two options Regular Time or Over Time and based off of what the user selects for example the regular time rate would be 30 and the overtime rate would be 1.5 times the regular time rate being 45.00. I want the app to automatically calculate what the labour total would be based on what the user selects from the enum column
Right now It will automatically calculate with this formula for the regular time rate
[Regular Time Rate]*[Number Of Hours]
Solved! Go to Solution.
To clarify @1minManagerโs snippet, since some was lost to formatting:
IF(
[EnumColumn]=โRegular Timeโ,
[Regular Time Rate] * [Number Of hours],
[OverTime Rate] * [Number Of hours]
)
IF(
[EnumColumn]=โRegular Timeโ,
[Regular Time Rate][Number Of hours],
[OverTime Rate][Number Of hours]
)
Assumes [Regular Time Rate] and [OverTime Rate] are columns which are numbers, decimals or price type
To clarify @1minManagerโs snippet, since some was lost to formatting:
IF(
[EnumColumn]=โRegular Timeโ,
[Regular Time Rate] * [Number Of hours],
[OverTime Rate] * [Number Of hours]
)
@Steve how do I stop it doing that?
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |