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())
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try columns

Profile Total =
IF(Table[Product Type] = "Profile"), Table[Quantity]*1000, BLANK() )

and

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