We offer scholarships to our camps and they vary. The business practice has been to adjust the price of camp tuition based on what was awarded. As we are looking to report out there is a question of how many recipients received camp at a discount? I'm trying to filter by variance to home value and it's just not working. Any thoughts on a better way to find this? My brain is broken!
Is the base camp tuition always the same price? Would something like this work where you just count the constituents and split into rows based on the price they paid? (Also filtered the widget to just the one production season)
You'd then see the count of constituents and the exact amount they paid.