Good day,
Suppose that I have this dataset containing the information on cost &revenue of multiple stores and it looks something like this:
| Region |
Store |
Revenue |
Cost |
| A |
Store 1 |
64 |
23 |
| B |
Store 2 |
72 |
26 |
| B |
Store 3 |
52 |
19 |
| A |
Store 4 |
41 |
45 |
or
Cost_Revenue_Data = data.frame(Region= c('A', 'B', 'B', 'A'),
Store = c('Store 1', 'Store 2', 'Store 3', 'Store 4'),
Revenue = c(64, 72, 52, 41),
Cost = c(23, 26, 19, 45))
I am using mutate function to estimate the profit (Revenue - Cost = Profit) of each store:
Profit_Data <- Cost_Revenue_Data %>% mutate(Profit = Revenue - Cost)
But I wanna make Profit = 0 if it's negative. So the final table should look like this:
| Region |
Store |
Revenue |
Cost |
Profit |
| A |
Store 1 |
64 |
23 |
41 |
| B |
Store 2 |
72 |
26 |
46 |
| B |
Store 3 |
52 |
19 |
33 |
| A |
Store 4 |
41 |
45 |
0 |
Basically if Revenue - Cost = Profit < 0, I wanna make it equal zero instead of having negative values. Anybody know how to do this?