Change in Percentage Calculation as per Percentage Values

[deepaks77134599]

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...

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%

[deepaks77134599]

Problem Solved