Referencing the same number in a month over time

Hi @rykasa ,

Assuming you have the following :

1. Metric Services_Bookings dimensioned by Product
2. Metric Services_Hours dimensioned by Product and using a property inside the Product dimension
3. Metric Services_Hours_x_Month dimensioned by Month and Product. You could have a conditional formatting that check the total of this metric is matching the previous one.
4. Metric Revenue_x_Month dimensioned by Month and Product will have the following formula :

   'Services Bookings'
   /'Services Hours'
   *'Services Hours x Month'

   Given your example, each hour will be $ 333.33

Let me know if that’s what you expected.

Thanks for you quick response. I have 3 months of Services Bookings for the same product all with different $ amounts. The Services Hours by Product by Month are standard regardless of what month the Services Bookings happen in. The Services $ per hour will be different because the Services Bookings $ are not standard (sometimes $100K, sometimes $50K, etc.) which changes the Services $ per hour. To book Services Revenue, how do I reference the Services $ per Hour from the Services Booking Month for each future month of revenue?   

Hi Rykasa,

You should first calculate the full amount, Hours X Price

Then spread this amount over months:

SPREAD(AMOUNT,MONTH,X)

X being a number, probably a time estimate by product (or any other dimension)