Hi Dan, Thanks for your response. Users can select all the prompts, but my filter looks at the lowest level he is entering on the dashboard prompt. This is a commentary requirement. I used the same logic (in the attached doc) to enter the prompt value to 'Level 3' only into the commentary table. So, they are expecting the…

Hi Gianni, Thanks for your response. Yes, I wanted to achieve what my code is trying to do! Filter should pick up the non null value (only one value) by searching from Level 7 through Level 3. "is not working" = ? Answer: when I choose a value from the dashboard prompt, then it doesn't refresh the report. What does it…