I used some SQL to get some data back from FM.
I have problems with the returned data, that means numbers contains decimal places. I dont want them so I wanted to use round (column, 0) function in a query (without success).
That is the query, that I used in executeSQL function inside a set variable script step:
..."SELECT worker_name, round( sum( revenue ), 0 ) FROM sales where worker_name IS NOT NULL group by worker_name"...
I could´t manage function to work. If I run executeSQL without round function in a query everything works fine.
Is that not supported in FM or is the query wrong? I am not quite sure that must I admit
Please share some your opinion and experience on that topic!