I’m trying to figure out a way to determine if a ‘Number’ is between two values. To calculate this number I use avg(select()) to filter out for dates and specific users so it’s a very lengthy equation to have multiple times in IFS() statements.
Is there a way to store the calculation in a variable or use it in a Switch() statement?
Switch(‘Number’, 2 < 5, a, 5 < 8, b, 8 < 10, c, 10 <, d).
Hope that makes sense, cheers.