Forum Discussion

Gianfranco's avatar
Gianfranco
New Member
3 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
    3 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
Community Champion
3 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,

Gianfranco's avatar
Gianfranco
New Member
3 years ago

Hi

 

thanks - I tried but I always have an error 

The error returned is the argument of the function roundup has not correct datatype or the result is too big or too low

 

If you can help me thanks in avance!

G

 

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    Gianfranco ,

    In order to help you better, please post a few rows of sample data for each of your two tables 'Comesse' and 'Formati'.  Do not include any sensitive data.

     

    • Gianfranco's avatar
      Gianfranco
      New Member
      3 years ago

      Hi,

       

      thanks for the suggestion to post some data.

      I realised that it could be in some cases that the first argument of the division coudl be 0. 

      this could affect the formula and generate the error ? 

       

      Thanks

      g

      • rsbin's avatar
        rsbin
        Community Champion
        3 years ago

        Gianfranco ,

        If the first argument, commesse'[N_Stampe], is 0, this will evaluate to a 0, so I don't believe that is the issue.  0/anything = 0

        If the second part (the denominator) is 0 then this will throw an error.  You can wrap the entire thing with an IFERROR.  Perhaps your LOOKUPVALUE could be failing somewhere.