Highlighted

Change in Percentage Calculation as per Percentage Values

Avatar

Avatar

deepaks77134599

Avatar

deepaks77134599

deepaks77134599

29-05-2018

I want to calculate Percentage change as per Percentage values not on numbers but i am unable to calculate it, please help...

Description of the Problem- Calculate change in percentage last year vs this year visits considering percentage values not numbers

  • This year visit Logged in- 10%
  • Last year visit logged in- 9%
  • This year not logged in visit- 90%
  • Last year visit not logged in- 91%

Calculation:

{ Target date range visits ( visits/total visits * 100) - Compared date range visits (Visits/total visits * 100)} / Compared date range visits (Visits/total visits * 100)

But calculation is automatically happening by system considering numbers not percentage values, attached snap-shot for reference. please help...

ChangeCalculation_AsPer_PercentageValue.JPG

Change in logged in: 18.7 - 20.5 / 20.5 = - 0.088 * 100 = - 8.8% ( I wanted to calculate in this way)

But system is calculating: 3,234,353 - 2,755,406 / 2,755,406 = 0.1738 * 100 = 17.38%

Replies

Highlighted

Avatar

Avatar

deepaks77134599

Avatar

deepaks77134599

deepaks77134599

31-05-2018

Problem Solved