Can't do ROUND(SUM(field)) in NAB Data Source Editor

[TonyDB]

I would like to create a data source where I take the sum of a field, and then round it using ROUND(SUM(fld1)) for a field named fld1. Currently, when I try to do so, I get this error:

SQL0122 - Column *N or expression in SELECT list not valid.

[Johnny Major]

Hi,

Thanks for the information and looks like the SQL data source is injecting the RRN when it shouldn't be which is causing the error

We will get this fixed in the next update and for the meantime you could create an SQL View and use that until this gets fixed

Thanks

[TonyDB]

Thank you!