Calculate Hourly Rate

[bhmiller89]

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 

[v-caliao-msft · Accepted solution]

@bhmiller89 

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

[Greg_Deckler]

Probably create a couple measures like:

Projected = SUM([NonRecurringServicesTotal Actual])/SUM([NTE Hours])

Actual = SUM([NonRecurringServicesTotal Actual])/SUM([Duration])