Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a expression I want those assessment which are greater then 7 as in values and for criteria P10.then my value should be y otherwise n.
if(Criteria No='P10' and Assessment >7,'Yes','No'),
but its not showing everything no for all the P10. , when I m selecting P10 from list box then it showing values . I want this to filter for a particular expression automatically for criteria P10 for particular iD.
for each Id I have P1 to P10 then for every id and for every P I have some Y ,N value.
so now I have to match all the values of P10 and P8 for all the ID.
columns are
ID P value
1 P1 Y
1 P3 N
1 P8 Y
2.
so on..
hi,
can you please provide sample data and your expected output?
Thanks
Ravi
Hi Yogita,
Could you please check that,
how many no of id are available in P10 and that all id are available when you include the Assement > 7.
It may be the possible some of the id which assement value is less than 7.
If possible can you share the sample of your issue.It could help to provide the exact solution.
Thanks
Kumar KVP
share sample app with expected result to make it more clear.
ID | CriteriaNo | Brand | value | P11 | p10 |
4 | No | NO | |||
4008429037894 | P10 | Dre | 4 | No | NO |
3065890123878 | P10 | Pe | 4 | No | Yes |
3065890123892 | P10 | Pe | 4 | No | NO |
3065890123915 | P10 | Pe | 4 | No | NO |
3065890124035 | P10 | Pe | 4 | No | Yes |
5010394001441 | P10 | Pe | 4 | No | Yes |
5010394984577 | P10 | Pe | 4 | No | Yes |
5010394984584 | P10 | Pe | 4 | No | NO |
5010394986052 | P10 | Pe | 4 | No | Yes |
5010394986076 | P10 | Pe | 4 | No | NO |
5998749105214 | P10 | Pe | 4 | No | Yes |
5998749109113 | P10 | Pe | 4 | No | Yes |
5998749110027 | P10 | Pe | 4 | No | NO |
5998749110409 | P10 | Pe | 4 | No | Yes |
5998749115480 | P10 | Pe | 4 | No | NO |
8410136001574 | P10 | Pe | 4 | No | NO |
8410136001659 | P10 | Pe | 4 | No | NO |
3065890123878 | P11 | Pe | 4 | No | NO |
3065890123892 | P11 | Pe | 4 | No | NO |
output I need from this is
for every brand for each id there are multiple criteria like P10 and P11.
so I have values of P10 and P11 criteria for each id that falls under this criteria and which belong to particular brand.
I want to see according to brand for each Id I have some values for P10,P11.
so if this id pass in both the criteria then it should be yes otherwise no.