5 Replies Latest reply on Jan 13, 2019 11:26 PM by nidhi tanwar

# Calculate the % of a cell value of another cell value

I have the data  as:

MonthABC
Oct201823018034
Nov2018456223343

Now I want to calculate the % of B/A. How to do that ?

• ###### 1. Re: Calculate the % of a cell value of another cell value

HI Nidhi,

If you data is at Month level of details, then to achieve % if B/A would be, creating a calculated filed:

1. Create calculated filed B/A.

2, Right click on the calculated field, and in Format -> Numbers ->Percentage.

If the level of details is not Months, the percentage changes to SUM(B)/SUM(A).

Hope it helps, do mark it if it does..

Thanks,

Amar.

• ###### 2. Re: Calculate the % of a cell value of another cell value

Hi Amar,

How to calculate the SUM(B)?

I think, I might have not explained the question well in the above post. Please find the sample sheet attached for the better understanding of the issue.

The A,B,C are the different values in a column for which I need their total value. How to calculate the individual cell value ?

Thanks.

• ###### 3. Re: Calculate the % of a cell value of another cell value

Please find the attached workbook in version 10.5.

Hope you have a version higher then this.

• ###### 4. Re: Calculate the % of a cell value of another cell value

Thanks Amar,

But in the sheet attached total Percentage has been calculated i.e Sum(A)/total Row value.

I need to calculate Sum(B)/Sum(A) i.e for Oct 2018 it should show event B value as 4/7=0.571.

Thanks.

• ###### 5. Re: Calculate the % of a cell value of another cell value

Hi Amar,

I able to fetch particular column values using calculated parameters. However, while calculating the % it is showing as 0%. Can you please help me with it. Attaching the sheet for reference.