Common-sized Calcuations

Solved4.48K viewsFormulas and Functions

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.

S A U Changed status to publish October 30, 2018

Hi Mark,
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

S A U Changed status to publish October 30, 2018

Thanks, Sau.

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).

Thanks again!


Okay, figured it out – formula needed Actuals category modifier.

Still, is this the most efficient forumula?


As promised, here is the screenshot for the message above if you have not upgraded to Version 6.