1 Reply Latest reply on May 9, 2017 7:53 AM by Shinichiro Murakami

    Error-expected then to match if at character 0

    deepthi.dekkala

      I have written a calculation such that if a dimension has those values and a date function it needs to display a measure value.

       

      Reference:

       

      IF(ATTR([Sun_Penders (DSM)].[Stat Cd])= "PS" AND "UW")

      AND IF (DATEDIFF('month',[Tran Dt],TODAY()) <=13) THEN SUM([Anp Lc])

      END

       

      It throws an error - expected 'then' to match 'if' at character 0

       

      Can anyone please let me know the reason??

       

      Appreciate any help !! Thanks!!