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!
Would using an IF formula work? Something like: IF(Ticket Home Value > Ticket Value, COUNT(Constituent ID),0)
This definitely gets me closer! If I use a row of recipient or order number it gives me the correct total for each line but if I try to group it by performance or production season to get the total it gives me a number that's too high.