Forum Discussion

dkehoe32's avatar
dkehoe32
Helper I
8 years ago
Solved

Modify calculation in a column based upon a blank in another column

Im trying to modify the price impact column so that if the word "blank" shows up a calculation doesnt happen in the other columns   
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Add new calculated column "Impact"

     

    Impact = 
IF ( Table[blank] = "blank", 0, DIVIDE(Table[Number1] , Table[Number2]))
dkehoe32's avatar
dkehoe32
Helper I
8 years ago

There's only one table.  Hopefully the pasted info below makes it more clear

parry2k's avatar
parry2k
Super User
8 years ago

Add new calculated column "Impact"

 

Impact = 
IF ( Table[blank] = "blank", 0, DIVIDE(Table[Number1] , Table[Number2]))
  • dkehoe32's avatar
    dkehoe32
    Helper I
    8 years ago

    That worked.  Thank you!