2 Replies Latest reply on Sep 13, 2018 8:59 AM by Nikos Fournarakis

    Why "current specification is invalid" for some of the calculated fields

    Dian Jiao

      I am modifying old workbook by switching datasource. We were using internal MS SQL originally. Since we have moved most of the data over to Postgres hosted in AWS, we need to rebuild the workbook by changing the data source while keep everything else the same. Due to the naming difference between MS SQL server and Postgres ( fields are in upper case for former, lower case for latter), I had to update references for all the fields. Most of the stuff is fixed like that. However, I noticed that some of the calculated fields have issue (exclamation point).

      measures.PNG

       

      If I open up any of them, it would say "current specification is invalid" but "calculation is valid".

       

      invalide.PNG

       

      I googled it and could not find anything helpful with this error. What exactly does it mean by "specification is invalid"?