Margins Help

­­General Discussions
1

Hi - I am looking for some guidance/recommendations on how to best implement Margins calculations.

I currently have a Gross Margin % built out as a STAT Account. However, I am needing to look at Gross Margins for specific G/L accounts and the COS accounts that tie to them. I am trying to not create individualized gross margin formulas for every scenario but I may have too.

Could a Gross Margin Calculation be a Version Calculation if I use an MDX formula? Or would that not work due to the specific account criteria that might pop up?

Thank you!

2

How is your P&L set up in both the ledger and financial statements, and how are you bringing that into your Prophix Cube? i.e. is P&L segmented, do you have dimensions/subaccounts baked into your account structure, etc.