Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please find the attachment
I want the output as count(column (C))='MET'/total count of (Column (C))
i.e., 3/6 = 2 to be shown in a text box.
would appreciate your help
May be this:
=Count({<name={"=A=B"}>}name)/Count(name)
It is not working
Have you looked at the attached sample? Seems to be working for me unless you have a different data model in your original app
I downloaded the attachment, it looks different what i gave it to you . but still i managed with your suggested expression. it doesnot work for me. to be more meticulous i have used dimension(name) as separate table and in expression i have added 3 expression like (exp1 - with pick match functions, exp2 - with pick match function, exp3 - exp1 compared to exp2...) and i would like to show the values in text table as required.
please help
My bad, may be I might have added the wrong qvw file
Have sent you the requirement to your email id...