Forum

This content is now out of date.

Visit Our Community

Net profit as a % of revenue

Hi

I am trying to create a report that shows the percentage of our revenue that falls to the bottom line as profit. The attached excel file shows what I am trying to achieve. I want to create column C in my YF report.

I have tried some advanced functions, but as revenue is not the total of column B, I have not come up with a solution. Can you provide guidance?
Thanks and regards

Paul
Hi Paul,

if can you get the Net Profit value via a report-level calculated field:


Forum image


then you could re-use that calculated field in another calculated field that calculates the percentage of the Net Profit:


Forum image



regards,

Dave
Hi David

Thanks for the guidance. I will think about how I can get the desired result by using a calculated field and re-use that result in another calculation.

I came up with a similar but slightly clumsy solution using a parameter. I run the report, then feed the result from the key row into the parameter field. Your solution would be more elegant.

Regards

Paul

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.