variable help

[#1]

Hi, i need help with this problem i have..

this is my 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.

Can anyone help please?

[alexandros17]

Give me the variable description

[#3]

Hi,

this is my variable. it is made up of other varibales so i will lest them all..

LET vDaysInRangeTMP = '=networkdays(vMinEventDate,vMaxEventDate,$(vBankHolidays))';

vMaxEventDate and v MinEventDate are just made up of the min and max of [Event Date]

and the vBankHolidays is made up of..

concat(distinct num(HolidayDate),',') AS PublicHol

I hope this is clear

[#4]

Does anyone have any ideas?