
1. Re: Rounding issue occurring while dividing the values
Simon Runc Sep 13, 2018 2:40 AM (in response to Vijay Oswalia)hi Vijay,
So if we break down one of the rows
Your Calculation is
[2018 wieghtage]/[2017 weightage]1
So this is 0/0.125 = 0
Then 01 = 1
Why do you have the 1? It looks like the weightage calculation returns a percentage, and traditionally you show differences of percentages by taking one from the other, and not the percentage change of a percentage.
Hope that helps
If you let me know the result you expect for the row example I've used I can take a look.

2. Re: Rounding issue occurring while dividing the values
Mahfooj Khan Sep 13, 2018 2:57 AM (in response to Vijay Oswalia) 
3. Re: Rounding issue occurring while dividing the values
Vijay Oswalia Sep 13, 2018 3:11 AM (in response to Mahfooj Khan) 
4. Re: Rounding issue occurring while dividing the values
Simon Runc Sep 13, 2018 3:12 AM (in response to Vijay Oswalia)Ah...I see
So you just need to aggregate it at the level you want to calculate
SUM([2018 weightage])SUM([2017 weightage])/
SUM([2017 weightage])
If you look at your 2017 and 2018 weightage...they are both wrapped in SUM so you need to reflect this in the variance calculation

5. Re: Rounding issue occurring while dividing the values
Vijay Oswalia Sep 13, 2018 3:36 AM (in response to Simon Runc)Thanks Simon, its working now.