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

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