Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody!
I have a problem with my expression
I want to count some products when the type is PEND but not when the type is FACT.
Product | Type |
1 | FACT |
2 | FACT |
3 | PEND |
1 | PEND |
4 | PEND |
In this example The result must be 2, becahuse of products 3 and 4. The thing is that product 1 should not be count because it is FACT too.
I feel it is simple but I can do it myself,
Thanks in advance!
May be this:
Count(DISTINCT {<Product = e({<Type = {'Fact'}>})>}Product)
Or when you need to filter on Type = PEND and there are more than these two types shown:
Count(DISTINCT {<Product = e({<Type = {'FACT'}>}), Type = {'PEND'}>} Product)
The solution you gave me is very helpfull in the example I submit.
The problem is that I have one more condition that is not working.
Product | Type | Va |
1 | FACT | 0 |
2 | FACT | 1 |
3 | PEND | 1 |
1 | PEND | 1 |
4 | PEND | 1 |
5 | PEND | 0 |
5 | FACT | 1 |
I am trying to filter only values where Va = 1 and then to count the PRODUCTS for PEND but not for FACT, only PEND.
In this case the solution is 3 (because the products 3,1 and 4)
I really do not know to work with the expression. Please Help me!
Try this:
Count(DISTINCT {<Product = e({<Type = {'Fact'}>}), Va = {1}>}Product)
=Count(DISTINCT {<Product = e({<Type = {'Fact'}, Va = {1}>}), Va = {1}>}Product)
Hi Sunny !
Thanks a lot for your help. You are been verry helpfull.
I understand what you do, and it works for me in the example I gave you. But it is not working on my aplication.
Can you please see it? It is making me go crazy.
The example is the same , but the fiels have differents names. SKU is a Product and se_Cumple is Va.
Now i am working with NODO =91, and I know that we have 292 SKU for PEND and 414 SKU for FACT.
Only 5 SKU and ind PEND but not in FACT, this are: 552495, 572637, 572639, 575806, 583366
The graph I am working is showing nothing now. I clear the board so it will be very easy for you to see how it is working.
!
I really need you help, please!
I don't see a graph in your application? Can you guide me where to locate it?
sure !!!
Please let me know if you can see ir. the problem is that with my expression there is nothing to show !
I am not sure if you receive my answer because I see a message "Actually modarated" or something like that beacuse i see it in spanish.
I try this way too:
the problem is that with my expression there is nothing to show !
Let me know if you see the picture and the graph .
Thanks a lot!!!
This?