2 Replies Latest reply on Aug 11, 2016 9:26 AM by Aaron Lum

    Valid calculation but null/invalid field?

    Aaron Lum

      I have a calculated field that is valid (details greyed out) but in my data source table, all the values are null and there is an exclamation(which I understood to mean invalid calculation)? It consists of a sum of a field in this table divided by the sum of a field in a table on a different server. Any ideas on what this means?




      What's more confusing is that when I plot this field, I actually get a chart even though the values are null:


      Another addition to this confusion is that if I make another calculated field based on the one aforementioned where I try to make null values = 0 instead of just null, I get the same thing:



      Perhaps these are unrelated issues but would still appreciate any help on understanding this!