Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have you looked at the Reference Number field to see if there is any data?
I guess reference number field is different in Ur local and published copy,Chech the validity of the column
Thanks for the replies.
Data field is there.
Another formula =count([Reference Number]) is working fine on the sheet. This one is represented in Total # of Responses.
Just that when distinct is added to the mix.. it somehow disappears. And outputs a '-'
Can you post a sample qvw that shows the problem?