Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a simple table with a dimension (Part Number), two expressions (Quantities) and a calculated dimension (difference)
Code | Difference | Qty 1 | Qty 2 |
09305002XYR0007 | 0 | 1,848 | 1,848 |
09305005XYR0B00 | 462 | 924 | 462 |
09305005XYR0007 | 0 | 693 | 693 |
09305006XYR0006 | 0 | 462 | 462 |
I would to filter the table to have only the codes with a difference <> 0. In this case it would show only this:
Code | Difference | Qty 1 | Qty 2 |
09305005XYR0B00 | 462 | 924 | 462 |
I tried many things as conditional or dimensions limit but no-one works. Any suggestions?
Thanks
What is the expression you use behind the calculated dimension Difference?
Try Using the below:
=if(difference<>0,1,0)
What if you create measure for difference, and use measure for Qty1,Qty2 and difference like below -
- If(Sum(Qty1)-Sum(Qty2)<>0, Sum(Qty1))
- If(Sum(Qty1)-Sum(Qty2)<>0, Sum(Qty2))
- If(Sum(Qty1)-Sum(Qty2)<>0, Sum(Qty1)-Sum(Qty2)) //Difference measure
In Add-on properties, disable 'show zero values' if needed