Forum Discussion

edhans's avatar
edhans
Community Champion
7 years ago

Service Report Differs from Desktop app - null rows

I know there was an issue in June with the NULL field and not being calculated properly, but it seems to still exist, at least in the service.    I have the following M code in a table: let So...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI edhans ,

Can you please share a sample file for test? I can't reproduce this on my side.
In addition, have you try to filter with other keywords?(e.g. " ", "")
Regards,

Xiaoxin Sheng

  • edhans's avatar
    edhans
    Community Champion
    7 years ago

    It goes to my SQL server, so not sure how I can provide a set of sample data. I would be glad to PM you the file if desired, but without the backend database, not sure how that would work.

     

    I am 100% sure it isn't a "" or " " issue, because by simply setting the type to text (it is already text) fixes it, which is reminiscent of the other null bug that we had last month that is you reapplied the same data type to the field, subsequent handling of NULL worked correctly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi edhans ,

      Maybe you can open a support ticket to report and get better support for this:

      submit a support ticket

      Regards,
      Xiaoxin Sheng