Forum Discussion

Kfausch's avatar
Kfausch
Icon for Helper II rankHelper II
5 years ago
Solved

ROUNDUP only on decimal

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!
Need Help
  • fhill's avatar
    fhill
    5 years ago
    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?

    fhill_0-1603309103429.png

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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])

  • fhill's avatar
    fhill
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago
    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?

    fhill_0-1603309103429.png

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Kfausch ,

     

    Is your issue solved now?

     

    Best Regards,
    Kelly

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