Forum Discussion

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

Add new calculated column "Impact"

Impact = 
IF ( Table[blank] = "blank", 0, DIVIDE(Table[Number1] , Table[Number2]))

4 Replies

Greg_Deckler
Community Champion
8 years ago
So, what are you having an issue with? Do you have two tables involved here or just one?
- dkehoe32
  Helper I
  8 years ago
  There's only one table. Hopefully the pasted info below makes it more clear
  - parry2k
    Super User
    8 years ago
    Add new calculated column "Impact"
    
    Impact = IF ( Table[blank] = "blank", 0, DIVIDE(Table[Number1] , Table[Number2]))