Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Prodcut | Attribute1 | Attribute 2 | Attribute 3 | Attribute 4 | |
A | 1 | 3 | 1 | 1 | Count(Duplicate values required) |
B | @ | @ | & | @ | count(special characters) |
C | W | W | count(Blank rows) |
1] For the product A Need Count of Duplicate values
2]For Product B Specail Characters count required
3] For Product C Blank & Null Characters count required
Message was edited by: Anil Kadiri
Please find attached. Depending on how your data model is, the attached might work for you. I did it two ways, one where your attributes are all one field and the other where they are separate fields. Also I only did the specials characters @, &. If you want to add more, you can.
PFA
Hope this helps!
Experts Could pls suggest me some solution for the above
Please find attached. Depending on how your data model is, the attached might work for you. I did it two ways, one where your attributes are all one field and the other where they are separate fields. Also I only did the specials characters @, &. If you want to add more, you can.
PFA
Hope this helps!
Awesome work.thank youso much for your great effort
For this expression count should be 3 but it is showing 2 .
=count({<Product={A}>}Value) - count({<Product={A}>}distinct Value)
I Need Reptead count
Ans:3.
How can i achive this ?
That is a littler trickier. There are 3 instances of one in your example, but there are 2 distinct values. What that equation is doing is counting the number of repeated values after the first instance. So there are 3 instances of one, but then it is repeated twice.
If you are looking for the number of times a duplicated number appears, then that would be 3. Took a little bit of work, but I think this formula will suffice:
=count({<Product={A}>}if(aggr(nodistinct count(Value), Value) >1,Value))
Hope this helps!
Thank u.Its working.