This might be a bit clearer of what i want to do..
this is my current expression..
=$(vDaysInRangeTMP) - sum(AbsentFlag_ISS)
I want to stop the variable from reacting to selections apart from the field [Event Date], the 2nd part of the expression needs to change on selection, so its just the varibable that i want to limit.