Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need an expression that only shows BIN where the QUANTITY = 0? I don't need any other fields to be displayed.
What kind of expression do I need?
You mean to say this?
Only({<QUANTITY = {0}>}BIN)
May be like this
Dimension
Bin
Expression
If(Sum(Quantity) = 0, 1, 0)
When I use this as an expression, it returns the same amount for the BIN and the expression. I tried it as an dimension and it didnt work
This is just displaying 1 for everything? I only need to show BINS where the QUANTITY = 0?
Really? Even if use this if statement which says that only show 1 when Sum(Quantity) = 0, assign a 1, else a 0? Can you share an image after adding another expression
Dimension
Bin
Expression
If(Sum(Quantity) = 0, 1, 0)
Sum(Quantity)
Can you show the image, And explain the result
Oops sorry that was my fault. You're right, thanks!