Conditional Mutate - Make negative values zero

General
1

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?

2

Try this:

Profit_Data <- Cost_Revenue_Data  %>% 
  mutate(Profit = ifelse(Revenue - Cost < 0, 0, Revenue - Cost))
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.