Missing opperand after 'of' operator

Help
1

Hi @Lahiru.Fernando
i am trying to group by two column values and do the sum, but i have stuck with these error can you help on this ?

Thanks

image|588x373

image

image

2

Hi @balu

It is because the column name contain spaces… You might need to change the column names to remove spaces…

3

Hi @Lahiru.Fernando

Its working fine but how could i get whole table data bcz i see nly columns mentioned in aggrigatecolumns and groupby columns are available in final output.Also how can i get headers for these ?

Thanks

4

Hi @balu

You can simply add the columns you need to show in the final output to group by columns and aggregate column properties according to how they want to be grouped or aggregated…

To get the column headers I guess you are doing a write range right? Enable the add headers option and see…

1 Like