Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I get a value for the cumulative value of any given ratio? I am computing Manufacturing Profit Margin % = Manufacturing Profit / Total Sales. I am trying to write an expression that will sum compute the overall value by taking Manufacturing Profit 1 + Manufacturing Profit 2 +Manufacturing Profit 3 / Total Sales 1 + Total Sales 2 + Total Sales 3 = Cumulative Manufacturing Profit Margin % for periods 1-3. Any help?
Not sure I completely understand, do you have sample data or app that we can look at?
Best,
Sunny
I simply want to cumulate the numerator and denominator before dividing to get the overall values of each.
Try this:
RangeSum(Manufacturing Profit 1 + Manufacturing Profit 2 +Manufacturing Profit 3)/RangeSum(Total Sales 1 + Total Sales 2 + Total Sales 3)
Or simply do this (but this might give you problems when you have nulls). RangeSum would be a better solution I believe.
(Manufacturing Profit 1 + Manufacturing Profit 2 +Manufacturing Profit 3)/(Total Sales 1 + Total Sales 2 + Total Sales 3)
Best,
Sunny
No that didn't work, here is what I have thus far, and it is still not calculating. I am using full accumulation, and will need to calculate my cumulative margin similar to what's attached in Excel.
=Sum({$<[Finance Data.Metric]={'Manufacturing Profit'}>} [Finance Data.Act/Fcst])
/
Sum({$<[Finance Data.Metric]={'Total Sales'}>} [Finance Data.Act/Fcst])
The file you attached is already accumulating Metric 1 and Metric 2? I wouldn't be able to help you if you don't give me a sample from raw data. I am not sure what exactly are you doing for accumulation. I hope that make sense.
Best,
Sunny
Here is a better example:
Month | 1 | 2 | 3 | Total | ||
Metric 2 | 23996 | 47980 | 33692 | 105668 | ||
Metric 1 | 6245 | 12489 | 22108 | 40842 | ||
Margin | 0.260252 | 0.260296 | 0.65618 | 0.386512 | This is what I want |
Any idea?
Give me sometime... checking it in a bit.
Best,
Sunny