Guest User

Untitled

a guest
May 26th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. variable <- c("Revenue", "Cost of Goods Sold", "Gross Profit", "SG&A", "Operating Income", "Interest Expense",
  2. "Pretax Income", "Income Tax", "Net Income")
  3. year_2014 <- c(6500, 3012, 3488, 1231, 2257, 231, 2026, 462, 1564)
  4. year_2015 <- c(3250, 1323, 1927, 912, 1015, 109, 906, 209, 697)
  5. year_2016 <- c(4965, 2723, 2242, 1159, 1083, 106, 977, 187, 790)
  6. df <- data.frame(variable, year_2014, year_2015, year_2016)
  7.  
  8. df <- df %>%
  9. mutate(percentage = year_2014/filter(select(year_2014), variable == "Revenue")
  10.  
  11. df <- df %>%
  12. mutate(percentage = year_2014/variable["Revenue"])
Add Comment
Please, Sign In to add comment