5 Replies Latest reply on Dec 19, 2016 2:14 PM by Yawen Yu

    How to Calculate =. without Syntax Error

    Yawen Yu

      Hello,

       

      I am trying to create a calculation where if the value is '.', then ONGOING is shown. Here is a bit of the data in question:

      calculation.PNG

       

      Since I want a dimension that displays COMPLETED or ONGOING based on the value, here is a calculation I created:

      calculation2.PNG

      The error comes from the fact I used =. Is there another way to calculate this without encountering syntax errors?

       

       

      Thank you,

      Yawen