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!