Simple example
dat1 <- data.frame(
stringsAsFactors = FALSE,
id = c("A", "B", "C"),
budget = c(1066500L, 100464L, 77618L),
personal_costs = c(658168L, 254310L, 67826L)
)
dat1$percent <- dat1$personal_costs / sum(dat1$budget) * 100
There are other ways to do this.
For a general outline for asking questions
A minimal reproducible example consists of the following items:
A minimal dataset, necessary to reproduce the issue
The minimal runnable code necessary to reproduce the issue, which can be run
on the given dataset, and including the necessary information on the used packages.
Let's quickly go over each one of these with examples:
A handy way to supply some sample data is the dput() function. In the case of a large dataset something like dput(head(mydata, 100)) should supply the data we need. Just do dput(mydata) where mydata is your data. Copy the output and paste it here.
1 Like