Forum Discussion

Gianfranco's avatar
Gianfranco
New Member
4 years ago
Solved

Round up

Hi,   coudl you please help me with the following. I have a column that makes the below calculation: N_Pellicole = 'commesse'[Strati] + ( ('commesse'[N_Stampe] / LOOKUPVALUE('Formati'[N_Formati]...
Need Help
  • Gianfranco's avatar
    Gianfranco
    4 years ago

    Hi, 

    i tried to wrap with an IFERROR and effectively the calcualtion works. 

    I doublechecked in xls that the output figures are consistent.

     

    just one small point: what does it mean when in the formula bar the box at the end is half grey and half red ? 

     

    Thanks

    gianfranco 

     

    Thanks

    G

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
4 years ago

Gianfranco ,

Dax has a ROUNDUP function.  You can google this to get more info.  But try something like this:

ROUNDUP( ('commesse'[N_Stampe] / LOOKUPVALUE('Formati'[N_Formati];'Formati'[Formati_xls];'commesse'[formato] ) ), 0)

// This should roundup to the nearest whole number.  Replace the 0 to indicate how many decimal places you want to round to.

Hope this helps.

Regards,