11 Replies Latest reply: Dec 17, 2015 8:07 AM by Erik Fröberg RSS

    DD - Measure Field returning NULL

    Jeremy Fourman

      Hello All -


      ODBC connection.

      Although my need is larger I have skinnied this down to a straight table with 1 dimension and 1 measure, the measure is sum(FIELD).


      Reload works fine and on state change I can utilize an ODBC trace I can see that the generated SQL is produced properly and when I execute the generated SQL directly against the database the correct totals are produced.


      I can also add a table box that contains only the measure field and I see values returned to the UI. Listboxes with dimensions seem correct. I can replace SUM(FIELD) with MAX(FIELD) and it gives me the largest value from the returned rows but SUM(FIELD) does not total and only produces NULL.


      Any ideas?