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 ,

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