Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following table:
Product | Category | Cost |
---|---|---|
A | X | 0 |
A | Y | 10 |
B | Y | -10 |
B | Z | 10 |
C | X | 0 |
C | Y | -10 |
I'm trying to filter the results as:
Products that have
1) Category equal to X
2) Does not have Category equal to Y and Cost greater than 0
So only product C meets those requirements. Product C has Category X and does not have Category Y where cost is greater than 0.
So I've tried:
Sum({< Product=P({< Category={'X'} >}), Product=E({< Category={'Y'}, Cost={">0"} >}) >} Revenue)
Any help greatly appreciated!
Sorry try this?
= Sum({< Product = P({< Category = {'X'}, Product = E({< Category = {'Y'}, Cost = {'>0'} >})>}) >} Revenue)
Try this?
= Sum({< Category = {'X'} , Product = E({< Category= {'Y'}, Cost = {'>0'} >}) >} Revenue)
Sorry try this?
= Sum({< Product = P({< Category = {'X'}, Product = E({< Category = {'Y'}, Cost = {'>0'} >})>}) >} Revenue)
Try
=Concat(
{<Product=P({< Category={'X'} >})*E({< Category={'Y'}, Cost={">0"} >}) >}
DISTINCT Product,',')
It worked! Thanks!