Forum Discussion
Calculate Hourly Rate
I did this before and now completely forgot what I did.
I have a colum called "NTE Hours" and a column "Duration" as well as a column "NonRecurringServicesTotal Actual" which is a dollar amount. The relationship is attached to a job number, multiple job reports are summed together to create "duration" where there is only one NTE Hours value per job number.
I need to calculate theprojected hourly rate as well as the actual hourly rate
Projected= NonRecurringServicesTotal Actual/ NTE Hours
Actual= NonRecurringServicesTotal Actual/ Duration
Any assistance on how to write this out is appreciated
Regarding how to wirte the formula depends on where you would like to use the result.
For example, if you would like to add the calculated results into the current table, we could write the formula in the following format:
As a calculated column:
Projected = DIVIDE(Table1[NonRecurringServicesTotal Actual], Table1[NTEhours])
ActualRate = DIVIDE(Table1[NonRecurringServicesTotal Actual], Table1[Durations])
See if this would help, and if any further help needed, please post back.
Regards,
Charlie Liao
2 Replies
Probably create a couple measures like:
Projected = SUM([NonRecurringServicesTotal Actual])/SUM([NTE Hours]) Actual = SUM([NonRecurringServicesTotal Actual])/SUM([Duration])
Regarding how to wirte the formula depends on where you would like to use the result.
For example, if you would like to add the calculated results into the current table, we could write the formula in the following format:
As a calculated column:
Projected = DIVIDE(Table1[NonRecurringServicesTotal Actual], Table1[NTEhours])
ActualRate = DIVIDE(Table1[NonRecurringServicesTotal Actual], Table1[Durations])
See if this would help, and if any further help needed, please post back.
Regards,
Charlie Liao
