The dashboard I am creating is using survey data. The people who do the surveys don't have to fill out every question and this causes problems when trying to show different data calculations. The problem occurs when the data is filtered.
Before it is filtered:
After if is filtered:
(After it is filtered it should show no data)
I have tried to use the indicators to say, if the current value equals undefined, zero, or blank then display N/A. I have also tried the same thing within the equation to get it to show N/A if there is no data to use for the calculation. But nothing seems to work.
This is the equation I have to get the current value:
Any help with this would be great.