Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
10 years ago
Solved

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. ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    10 years ago

    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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Probably create a couple measures like:

 

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

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