Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My business problem is to count the question id which have been answered with a particular answer , for example the mapping answers are present in filed A which have values like "Yes/No" or "Yes" , " No'
and the actual answer present in field B which have answers as "yes' "No'
and i have perform count of question when answer type matches with the mapping answer field A. The challenge is coming when mapping field is having "Yes/No' in that scenerio if it has answered as "yes" or as "No " both cases should be counted.
I am using below query which is not working:
Count({$<Acronym=P(Acronym), wildmatch(B,A)>}UID)/ count(Evaluation_ID)
Would you be able to share few rows of data and explain as to what you are looking to get as an output?