Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What I am trying to do is have QV show me the invoice price when description = 'A' but instead of just showing me 1 - A, I want it to show me all it's description values. In the set analysis I currently have Sum({$<Description ={'A'}>}Price). So essentially I am looking for something like if invoice has a value of A in description, show me all it's description values.
Invoice | Description |
---|---|
1 | A |
1 | B |
1 | C |
2 | F |
2 | B |
2 | C |
Try This
Sum({$<Description =P({1<Description={'A'}>})>}Price)
See attached example.
try this
Sum({$<Invoice =P({1<Description={'A'}>}Invoice)>}Price)
Thank you very much. I'm very curious about what that syntax actually means though.