9 Replies Latest reply: May 15, 2014 9:29 AM by Karunpreet Soni RSS

    Invalid Expression Error

    Karunpreet Soni

      Hi everyone,

      I have an expression which is running perfectly in the text box but when i use the same in my data model, its throwing an error called  'Invalid Expression'. The expression is:

      IF(SERVICE_INDICATOR='AESTHETIC',100*COUNT(IF(RESULT_VALUE > 15, RESULT_VALUE))/COUNT(TEST_ID))

      where SERVICE_INDICATOR, RESULT_VALUE and TEST_ID are the columns of my Fact Table, and I am using the above expression in the same Fact Table.

       

      Thanking everyone in anticipation