LookupObjectUnitValue is working when using the Cost metric. But we are interested in presenting the Rolling 12 Month value. When I replace Cost metric with Rolling 12 Month metric my totals are not changing. 

Does LookupObjectUnitValue work with metrics other than Cost? Why am I not seeing the Rolling 12 Months? 

Ref:

https://tbmcouncil.jiveon.com/docs/DOC-4974

Can you provide the formula that you are currently using and the one that you are trying to use please?

Current:

=LookupObjectUnitValue(Application Allocation,Cost,Business Unit Allocation Master Data.Business Unit,Application Allocation.Business Support Organization L1)

We want to replace "Cost" with "Rolling 12 Month", both of which are metrics.

Is Rolling 12 Month a Modeled Metric or just a calculated one? It may not be able to lookup the value if it's not a modeled metric? Just another thing I can think of.

I've done something similar but not in a pretty way. 

You could try making a new metric and have the formula as =TimePeriod(LookupObjectUnitValue(Cost),-12)+TimePeriod(LookupObjectUnitValue(Cost),-11)+...

This would give you 12 months ago, plus 11 months ago etc. until you get down to last month, then add LookupObjectUnitValue(Cost).

I've done this with just 'Cost' before but I think t would work with the lookupobject as well. 

Hope this helps