A&R Variance report shows incorrect variance %

[manuji]

Scenario:

• Navigate to the A&R on TEST environment: https://d3ahrzu0mpndj3.cloudfront.net/
• Select a Park, a Sub area and a month.
• Then enter data for 2022, 2023 and 2024 years so that it would trigger a variance.
• Export the variance report and check the variance percentage displayed

Expected:

• As per the Variance calculation the variance percentage should be displayed. eg: `if A is your average or comparison #, and B is your current year's number, the formula is (B-A)/B x 100, answer is a %

Example: 2017-2019 average for frontcountry camping at Bull Canyon Park was 779 people. 2022 attendance was 1,101 people.

(1,101-779)/1,101 = 0.29 0.29 x 100 = 29%

The 2022 attendance increased by 29% (or has a variance of 29%)`

Issue:

• The variance % displayed on exported report is incorrect.

eg: Tested using Park: Test park, Sub area: Test sub area for the Month of February with the Activity is Boating activity. Check the Nights on dock field.

Value for Feb 2022: 600 Value for Feb 2023: 638 Value for Feb 2024: 1101

Expected Variance: 29% Variance on Exported report: 78% -> Incorrect

Check the video given below

https://github.com/user-attachments/assets/6c022755-aca1-4ff8-a752-fd1c4235c9ba

[davidclaveau]

Hey @manuji! I took a look at this but I think the calculation of 78% is correct for that Test Park.

Value for Feb 2022: 600 Value for Feb 2023: 638 Value for Feb 2024: 1101

Expected Variance: 29% Variance on Exported report: 78% -> Incorrect

Let me know if my logic below makes sense:

If you have an average for 2022 and 2023 of 619 ( (600 + 638) / 2 = 619), and then 2024 is 1101, then your variance would be calculated like so:

• 1101 - 619 = 482
  • (2024 amount - average = variance increase from average)
• 482 / 619 = .7786 or 78%
  • (variance increase / average amount = variance %)

Similarly, say the 2022 and 2023 average were both 600. If we had 1200 in 2024 then you'd have an increase of 100% from the average.

• 1200 - 600 = 600
  • (2024 amount - average = variance increase from average)
• 600 / 600 = 1.00 or 100%
  • (variance increase / average amount = variance %)

So 1200 would be double the average of 600, or a 100% increase.

Let me know if that looks right and if my math checks out, but I believe that's how we're calculating the variances.

[manuji]

Acknowledged @davidclaveau , Thank you!