Hi guys
Here is another one.
I have an inventory table that looks like this.
You can see that the column called "vCo$t" has some records where the value is missing (zero or null)
| ProductID | Others | OH | vCo$t | sCo$t | Load | iCo$t | Delta | O$MI |
| 3/8-CHANNEL-GY | 2 | 200 | $1.17 | $1.32 | 12% | $1.13 | 19% | $0.00 |
| 4UGR | 1 | 2 | $41.58 | $46.74 | 12% | $41.58 | 12% | $20.79 |
| 5/8X17/32-EXT | 1 | 17,500 | $0.07 | $0.08 | 12% | $0.07 | 12% | $0.00 |
| 10-39-259 | 1 | 13 | $19.28 | $0.00 | -100% | $28.90 | -100% | $0.00 |
| 10-65-343 | 1 | 3 | - | $9.63 | - | $9.53 | 1% | $0.00 |
| 70-1639 | 1 | 55 | $15.05 | $16.92 | 12% | $15.05 | 12% | ($0.00) |
| 170-9098 | 1 | 265 | $0.23 | $0.26 | 12% | $0.03 | 654% | $2.28 |
| 170-9121 | 1 | 2 | $0.25 | $0.28 | 12% | $0.03 | 717% | $0.00 |
| 445-144 | 1 | 25 | - | $0.00 | - | $0.96 | -100% | $0.00 |
| 445-327 | 1 | 19 | - | $0.00 | - | $2.46 | -100% | $0.00 |
| 447-26 | 1 | 18 | - | $0.00 | - | $6.40 | -100% | ($0.00) |
| 600-11386 | 1 | 2 | $402.48 | $610.78 | 52% | $401.01 | 52% | $601.52 |
| 600-11387 | 1 | 2 | $582.16 | $883.45 | 52% | $618.53 | 43% | $618.53 |
| 600-11406 | 1 | 1 | $53.00 | $80.43 | 52% | $52.22 | 54% | $26.11 |
| 600-11411 | 2 | 4 | $53.00 | $80.43 | 52% | $56.72 | 40% | $26.11 |
| 600-11413 | 1 | 2 | $98.43 | $149.37 | 52% | $97.57 | 53% | $0.00 |
| 1040-026 | 1 | 7 | $1.48 | $1.66 | 12% | $1.48 | 12% | $0.00 |
I want to create a simple table that displays ONLY inventory where the vCo$t is zero or null.
I tried to use {<[vCo$t]={0}>} in the expression field for vCo$t but all it does is show all records and gives them all a null vCo$t
| ProductID | OH | vCo$t | sCo$t | Load | iCo$t | Delta |
| 10-39-259 | 13 | - | $0.00 | -100% | $28.90 | -100% |
| SIL-2 | 24 | - | $7.42 | 6% | $7.00 | 6% |
| URE-6 | 22 | - | $24.36 | 6% | $22.09 | 10% |
| RG-SIG-533-006-150-1800 | 7 | - | $39.75 | 6% | $37.48 | 6% |
| RG-SIG-533-012-35050X37038 | 4 | - | $111.70 | 6% | $105.32 | 6% |
| PANG-PRIMER-QT | 1 | - | $23.46 | 6% | $22.12 | 6% |
| SIG-533-006-60X60 | 3 | - | $500.04 | 6% | $471.47 | 6% |
| VITON-4 | 11 | - | $78.35 | 6% | $73.08 | 7% |
| PANGLAG60-5 | 308 | - | $14.32 | 6% | $19.65 | -27% |
| PANG-CEMENT-QT | 4 | - | $21.97 | 6% | $20.71 | 6% |
| SIL-4 | 20 | - | $13.62 | 6% | $13.85 | -2% |
| RG-SIG-533-006-150-0200 | 55 | - | $3.40 | 11% | $2.99 | 14% |
| RG-SIG-533-006-150-1200 | 10 | - | $33.00 | 11% | $29.70 | 11% |
| RG-SIG-533-006-300-1200 | 2 | - | $35.01 | 11% | $24.13 | 45% |
HELP!
Also, how do I use {[Field]={exp}>} if i don't have a formula like "Sum" or "Avg"?
Thanks
