I have a feeling I’m going to feel really foolish when I the solution.
I’ve hit a mental block on the formula for common sizing a simple P&L that I’ve attached.
I’ve tried two variations and yield the same results. The output is [b:233rsrt0]CORRECT[/b:233rsrt0], but not only does the formula not look right, the formula is being flagged.
I’m using version 6. If you have not upgraded, I will add a second message below for the screenshot. This forum does not appear to allow more than one file attachment.
Yes, I’m preparing myself to be embarrassed when I see the right solution.
I looked at your QM6’s model screenshot.
By itself, the formula number 3 is very simple. IMHO, it can and should be written in this form:
Percent to Revenue = Actuals / Actuals:Sales
I got it to work after posting my question. Here’s what worked for me (without getting flagged):
Percent to Revenue:Period = Actuals:Description/Actuals:Sales (which still didn’t look right)
But yours is more streamlined, and I’m rolling with it.
Interesting – three different formulas – three same answers (albeit one was flagged).