Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
Change in Percentage Calculation as per Percentage Values
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%
