Dataframe not loading on RenderDataTable

[colem]

I'm running some code where I'm trying to render a dataframe in a Shiny App. When I test the code locally without using a dynamic input filter the table is created ok, but when I run it in Shiny I get the following error. I don't see how this wouldn't be a dataframe.

Warning: Error in datatable: 'data' must be 2-dimensional (e.g. data frame or matrix)
[No stack trace available]

A summary of the code is

server <- function(input, output) {
  # Outputs for totals
  output$Total_tableAll <- DT::renderDataTable({

...

    Total_table<-Total_PremLoss %>% 
      group_by(CY)%>%
      dplyr::summarise('Booked Premium'=sum(Booked_Prem),
                       'Earned Premium' = sum(EP),
                       Commission=sum(Commission)/sum(EP),
                       Incurred=sum(Incurred),
                       ILR = sum(Incurred)/sum(EP),
                       'NonCAT ILR' = sum(nonCATLoss)/sum(EP),
                       'CAT ILR' = sum(CATLoss)/sum(EP),
                       'Comm ILR'= Commission+ILR)

    DT::datatable(data = Total_table,
                 container=cont_total,
                 rownames = FALSE,
                 caption = 'All LOB',
                 option=list(dom='t'
                 ))%>%
     formatCurrency(
       c('Booked Premium', 'Earned Premium', 'Incurred'),
       currency="$",digits=0)%>%
     formatPercentage(
       c('ILR', 'NonCAT ILR', 'CAT ILR', 'Comm ILR', 'Commission'))
)}

[andresrcs]

Hi, welcome!

To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue including sample data on a copy/paste friendly format? Please have a look at this guide, to see how to create one for a shiny app

Shiny debugging and reprex guide

Shiny issues can be challenging to resolve relative to other problems with your code or statistical methods. Shiny apps are often large, complex projects with interacting files. When seeking help from others it is considered polite to: First, do your best to work through RStudio's debugging tools to diagnose your issue on your own. Often those shiny logs and tracebacks are useful to others trying to help out. Second, strive to minimize the effort required to replicate your issue. You can do this with a reproducible example ("reprex"). Shiny Debugging Errors in Shiny code can be difficult to track down. If you don't know where your problem is coming from, you can track it down with some o…

[colem]

Just for reference I wanted to mention that I solved this. I didn't realize DT::renderDataTable({ required to have the table you are trying to render at the end of the wrapped statement. I moved this to the end and now it works ok.