Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

New column conditional

Hi all, I want to a new column with Profile Total only when Product Type = Profile, and GB Total only when Product Type = Storage. Does anyone know how I would do this in the context of the table bel...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Profile Total = IF([Product Type] = "Profile",[Quantity] * 1000,BLANK())

    GB Total = IF([Product Type] = "Storage",[Quantity],BLANK())
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Profile Total = IF([Product Type] = "Profile",[Quantity] * 1000,BLANK())

GB Total = IF([Product Type] = "Storage",[Quantity],BLANK())