Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Change in Percentage Calculation as per Percentage Values

deepaks77134599
Level 1
Level 1

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%

1 Reply