
1. Re: Calculate the % of a cell value of another cell value
Amar Wattamwar Jan 11, 2019 2:06 AM (in response to nidhi tanwar)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
nidhi tanwar Jan 11, 2019 3:44 AM (in response to Amar Wattamwar)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.

Sample.zip 30.5 KB


3. Re: Calculate the % of a cell value of another cell value
Amar Wattamwar Jan 11, 2019 3:58 AM (in response to nidhi tanwar)Please find the attached workbook in version 10.5.
Hope you have a version higher then this.

UsersEvents.twbx 31.1 KB


4. Re: Calculate the % of a cell value of another cell value
nidhi tanwar Jan 13, 2019 11:26 PM (in response to Amar Wattamwar)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
nidhi tanwar Jan 13, 2019 11:26 PM (in response to Amar Wattamwar)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.

UsersEvents.twbx 81.7 KB
