Calculating - Proportionate Share

[bigck2]

Hey community,

I'm trying to figure out how to calculate my company's proportionate share of revenues, expenses, etc.

I have two tables in my data model - FactData and SameStores. These are related by FactData[Property] on the many side, and SameStores[Yardi Code] on the one side.

In the FactData table each row is for a month and property/business unit and has columns like Revenue, Advertising Expense, Total Expense, etc.

In the SameStores table I have attributes about the properties, like our companies % ownership.

I'm trying to be able to get some measure to show our proportionate share of revenues, expenses, and net income.

Please let me know if you have any suggestions?

Thanks,

Chris