Announcements
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Using a ratio in the y-axis (Percentage) of a Scatter Chart.

Hello all,

I'm struggling with using a ratio percentage in the Y-axis. The ratio I'm using is the Contribution Margin Ratio. Essentially it is (Revenue - Cost) / Revenue

My end goal is to have an X-axis of Cost, Y-axis of contribution margin, and a Bubble size of overall Profitability. However, I can't seem to get a percentage for the Y-axis. I think I need to utilize Aggr, but I'm not quite sure. Here is my chart thus far.

I would like the contribution margin ratio to be in place of the Revenue axis.

Here is the formula and variables I'm attempting to use.

Formula: \$(vf_OverallProfitability)/\$(vf_OverallRevenue)

Variables and definitions:

Profit (Total revenue minus the expenses)

\$(vf_OverallProfitability)

(sum({\$<[Resource Type] = {'Retained'}>} [#Hours Billed] * #Rate)

-sum({\$<[Resource Type] = {'Retained'}>} [#Consultant Retainer Amount Entered]))

+

(sum({\$<[Resource Type] = {'Employee'}>} [#Hours Worked] * #Rate)

-sum({\$<[Resource Type] = {'Employee'}>} [#Salary Amount Calculated]))

+

(sum({\$<[Resource Type] = {'Contractor'}>} [#Hours Worked] * #Rate)

-sum({\$<[Resource Type] = {'Contractor'}>} #Amount))

Revenue

\$(vf_OverallRevenue)

(sum({\$<[Resource Type] = {'Retained'}>} [#Hours Billed] * #Rate))

+

(sum({\$<[Resource Type] = {'Employee'}>} [#Hours Worked] * #Rate))

+

(sum({\$<[Resource Type] = {'Contractor'}>} [#Hours Worked] * #Rate))

When I use the above formula and variables in the graph I get whole numbers and my data points disappear from the graph.

Any help would be greatly appreciated here, I've been stuck on this problem for 2 days now.

Thanks,

Channing

1 Solution

Accepted Solutions
MVP

Maybe use extra brackets like

( \$(vf_OverallProfitability) ) / ( \$(vf_OverallRevenue) )

2 Replies
MVP

Maybe use extra brackets like

( \$(vf_OverallProfitability) ) / ( \$(vf_OverallRevenue) )

Anonymous
Not applicable
Author

Feeling very silly now! Thank you

Community Browser