I am creating a report and noticed when using the above formula it is the Absolute Cost and not Net Cost. I have Service Name "Application Support - NAO) allocating from Business Services to Business Units. The Model Report and the Modeled Object show $98,835 which is correct
But when I enter a column with the above formula it returns 108924.877 (which is due to the credit numbers totalling (5,045)
How can I get the correct answer?
Thank you,
Hi @Dawn Kassube. Try using a LookupObjectUnitAllocation formula with the following syntax:
=LookupObjectUnitAllocated(sourceObject,destObject,metric,columnInLocalTable,columnInSourceObjectTable)
Hello @Dawn Kassube. I have used LookupObjectUnitValue(), with returns Cost, without any issues so far.
Hello Beth,
Can you please provide an actual example as I cannot figure out how to use this formula. Service Name is not a column in my receiving table as there are multiple drivers allocating to QBE All Business Units and they are allocating to Business Units by Headcount or Percentage.