5 Replies Latest reply on Sep 13, 2018 4:16 PM by Deepak Rai

    How do I calculate % of a column value

    Manas Mohanty

      In the attached workbook, in Sheet 5 I need to calculate the % or Risk Based Capital.

      Basically Risk Based Capital is a fvlaue in Report Head.


      % of Risk Based Capital should be Loan Composition Amount/Risk Based Capital. (This value lies in the Loan Composition amount for - Risk based capital.).


      For eg. % Risk Based capital should for Accumulated other Comprehensive Income (1st row in sheet 5) should be 15174/1547426. How do I achieve this?


      Hope this helps !!!


      Basically I need to calculate the % based on column value as we do % of grand  total. (i.e Loan Mix column)


      An urgent reply is beneficial.