Forum Discussion

zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
6 years ago
Solved

Complex 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...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
6 years ago

yes, sorry about the comma.  I originally wrote a MOD function, then changed it to INT but forgot to change the comma to a divide.  I think the last formula is correct as is.  You do not need selectedvalue because it is inside a SUMX over the products table.

 

total pallets =sumx(products,INT([lifetime to date]/product[pcs on pallet]))

zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
6 years ago

MattAllington 

The 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's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    6 years ago

    The 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.