Round to an existing value within my data set

Question

Hi all I hope you can help with the below.

I have a calculated field that returns the safety stock volume in KG of a product. EG 976  I also have a field that contains the pack size of the product in KG EG 25. I now need to calculate the safety stock value rounded by the pack size value so in this example 976 rounded to 25 = 1000. all my values are fixed decimal set to 3 decimal places.

DataNath · Answer

Hey @10005970, we can use the Ceil() function for that and pass through the pack size field to use as the multiple. Here's an example using your values:

Ceil based on mult in another column.yxmd

aatalai · Answer

@10005970 is that rounding to the nearest package size or rounding up? Also are there predefined packing sizes?