Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.

  • #2
    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

    Comment


    • #3
      Thank you!

      Comment

      Working...
      X