Hi All, Basically this is my code and I want to get the value of percentage, Category and HRLmean. when I run the code, it looks ok to me but the value of percentage, unrate or unemployed are zero. how do I find all these values? Thank you in advance!
labour_7 <- labour_2%>%
summarise(HRLmean=mean(HRLYEARN), HRLsd=sd(HRLYEARN),uemployed=sum(LFSSTAT=="3"), sum=sum(LFSSTAT),.groups = 'drop') %>%
mutate(unrate=uemployed/sum, percentage = unrate*100)