Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
HELP!
Also, how do I use {[Field]={exp}>} if i don't have a formula like "Sum" or "Avg"?
Thanks