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 ,

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.

     

    • Gianfranco's avatar
      Gianfranco
      New Member
      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