unexpected symbol error in my query

[Amjad266]

Hello everyone,
First time posting and new to here and in R. I have query already ready I just need to run and calculate the top 10% from Excel data file.
I am getting error
Error: unexpected symbol in "transmute(Lane_State,Sum(TOTAL_TOTAL))USbound_Period_End_P12_2022"
below is my query

USbound_Period_End_P12_2022<-USbound_Period_End_P12_2022%>% filter(CORP_YR_NUM==2022) %>%
transmute(Lane_State,SERVICE_CD,CORP_WK_NUM,CORP_PD_NUM,Sum(TOTAL_TOTAL))
transmute(Lane_State,Sum(TOTAL_TOTAL))USbound_Period_End_P12_2022>%>
arrange(desc(Sum(TOTAL_TOTAL))) %>%
group_by(CORP_WK_NUM,Lane_State) %>%
slice(1:ceiling(0.10 * n())) %>%

can anyone help me for this?
Thanks

[technocrat]

@Amjad266

TOTAL_TOTAL))USbound_Period

This message is almost always about punctuation. Try a , after the second )

[Amjad266]

This is after a ,
USbound_Period_End_P12_2022<-USbound_Period_End_P12_2022%>% filter(CORP_YR_NUM==2022) %>%
transmute(Lane_State,SERVICE_CD,CORP_WK_NUM,CORP_PD_NUM,Sum(TOTAL_TOTAL))
transmute(Lane_State,Sum(TOTAL_TOTAL)),USbound_Period_End_P12_2022>%>
arrange(desc(Sum(TOTAL_TOTAL))) %>%
group_by(CORP_WK_NUM,Lane_State) %>%
slice(1:ceiling(0.10 * n())) %>%

and still have error
Error: unexpected ',' in "transmute(Lane_State,Sum(TOTAL_TOTAL)),"

[nirgrahamuk]

It might be helpful for you to know how to properly format code and console output that you post here. Using proper code formatting makes the site easier to read, prevents confusion (unformatted code can get garbled by the forum software ), and is generally considered the polite thing to do. Check out this FAQ to find out how — it's as easy as the click of a button! :

FAQ: How to format your code

Formatting Code: the Basics All code or console output you include in your posts should be formatted properly. Luckily, this is very easy to do! Just use the code formatting button at the top of the post editing box: [image] Select some code Click the </> button! The code formatting button automatically adds special Markdown formatting symbols to whatever you selected. If you check the preview pane to the right of your post, you'll see that the forum software now outputs nicely formatted code . [04] The code formatting button is pretty smart! It can tell the difference between snippets of code that are part of a sentence and blocks of code that stand alone. …

[Amjad266]

USbound_Period_End_P12_2022>%>
arrange(desc(`Sum(TOTAL_TOTAL)`)) %>%
  group_by(CORP_WK_NUM,Lane_State) %>%
  slice(1:ceiling(0.10 * n())) %>% 

````USbound_Period_End_P12_2022<-USbound_Period_End_P12_2022%>% filter(CORP_YR_NUM==2022) %>% 
    transmute(Lane_State,SERVICE_CD,CORP_WK_NUM,CORP_PD_NUM,`Sum(TOTAL_TOTAL)`)
transmute(Lane_State,`Sum(TOTAL_TOTAL)`)