Hi
I am trying to create a new column "margin" which has the formula of ebita/revenue. How can I do that. Based On account number I determined what is revenue v/s EBITA. The problem here is revenue, ebita all uses column amount. How can I create a new field "margin column highlighted in red"? I have attached the workbook for the reference.
Thank you in advance for the help.
9 answers
I got your margin calc working, but added it to tooltip not sure how to add to the table.
Twbx attached.