Showing value only if criteria from other column met, if not show 0

[BobJohnson]

Hi Everone,

I'm trying to find a way to show only the value from one column that met the criteria from the other column.

Deal#	Status	Monetary Value
1	Won	100
2	Lost	100
3	In Progress	200
4	Won	50
5	Won	150
6	Lost	100

I want to show in a table a total amount made on Wins and Losses. I can set up a filter but i already have percentile calculations that won't work unless no filter is selected.

Is there a way to create a new Column in my data table that will show Value If Status is Won but 0 if false? 

Deal#	Status	Monetary Value	Value Won
1	Won	100	100
2	Lost	100	0
3	In Progress	200	0
4	Won	50	50
5	Won	150	150
6	Lost	100	0

Any help would be very appreciated.

Thanks,

Bob Johnson

[freginier · Accepted solution]

Hello @BobJohnson  I don't know if I understand your point.. Do you need a IF statement ? Value Won =  IF( Table[Status] = "Won", Table[Monetary Value],0)

freginier

[Anonymous]

Hi @BobJohnson 

I think the solution @freginier  provided is right, if it help you, you can consider mark it as a solution, or you can provide more information that can offer more suggestion for you.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.