ROUNDUP only on decimal

[Kfausch]

Hello,

I am trying to write a formula that rounds all numbers with a decimal up to the nearest whole number. My issue is that if the number is already a whole number it rounds the number, but I only want to round if there is a decimal.

Current formula:

Pallet Qty = ROUNDUP([Quantity On-Hand] / (CALCULATE(SUM('Item UOM'[Qty_per_Unit_of_Measure]), 'Item UOM'[Code] = "pallet") -1),0)

Result:

Want I want instead:

Does anyone have any suggestions on how to accomplish this?

Thanks for reading!

[v-kelly-msft]

Hi @Kfausch ,

Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[fhill · Accepted solution]

Column 'Table (2)'[QOH] / 'Table (2)'[Quantity per]

ROUND_UP - ROUNDUP('Table (2)'[Column],0)

Just using some quick math, I couldn't duplicate your problems, so I'm thinking it has something to do with the Calculate Nested function in the RoundUP. Have you tried to allow the Round_Up to reference your 'Qty Case/Tote' column (or is it a measure?) without doubled the math again in the formula?

[amitchandak]

@Kfausch , try with some if condition like

Pallet Qty = divide([Quantity On-Hand] , (CALCULATE(SUM('Item UOM'[Qty_per_Unit_of_Measure]), 'Item UOM'[Code] = "pallet") -1))

if
Pallet Qty new = if(max(table[desciption]) in {"A","B","C"} , round([Pallet Qty],0),[Pallet Qty])