Ok, when the [(QUANTITY1- QUANTITY2] != 0 i wanna have the "-" This is because the items aren´t delivered yet and there isn´t a finish date. And then i´d put "dont select nulls" (because the client don't wanna see the items that aren´t delivered yet)
Okay, so that should not be summed in that case. Got it. So use my second expression.
Just to clarify, when you type in '-', that does not make the value null, it makes it a string equal to a dash. If you want to truly have it null(), either user null(), or do not add the second parameter to the if statement: if([(QUANTITY1- QUANTITY2], max(Date))
If you don't add a third parameter to the if statement, it automatically sets whats not true to a null value.
I see now that i dont have the "-" in the second expression.
I have one question but if you prefeer i can´t put it in another thread.
Now i´m groupping by the num_web( is the "primary key" of the table). Should i aggregate by the dates too? because i dont know if the expression is taking the dates when i have 4 or 5 dates in the same num_web
Sory but this expression is a bit too dificult to mee.
Hmm i don't see any multiple dates for the web. Can you elaborate more on what u mean with "because i dont know if the expression is taking the dates when i have 4 or 5 dates in the same num_web"
Just to be save, I'd also put min around your Date field as well. If you say there are multiple dates for a CodigoWeb, then you'd probably want the longest stretch between any there. So:
