Hi @alisha.kumar.c and welcome to the Quick Community!
Quick Sight has some odd behavior that when ‘select all’ is selected, the parameter reads as ‘NULL’. Therefore you will need to account for null value as well in your formula. Take a look at the previous post shared below that covers a similar scenario. Let me know if this works for your case or if you have any additional questions!