Forum Discussion
zenisekd
Super User
Super UserComplex round up sumx issue
Hi folks, I am facing a problem that I have spent hours on and still can't crack it. Here is my situation: I am selling various products (A,B,...), each of kind of product is stored in my wareho...
This one works the way you wanted... See the file attached. But don't ask me about the formula. It's a bit of math trickery.
Best
D
zenisekdSuper User
Super UserThe total pallets formula works well, but the formula "pallets shipped", which is important to me is not working... it shows the measure works, but once I place it to the matrix, it gives an error.
MattAllington
Community Champion
Community ChampionThe only measure that will work in an additive way is the SUMX version, the other one will only work if there is a single product. But you say it works, then you say it returns an error, so I am not really sure what that means.