3 Replies Latest reply: Mar 2, 2016 2:15 AM by Tresesco B RSS

    error in expression

    naveen kumar

      Hello guys

      Is there any thing wrong with this expression,


      i took two straight table ,one on top and other at bottom

      the top table has dimension :name1 and there related expression

      so the requirement was,when i select a value from the name1 field then  that selected value related qm_score has to display on the bottom straight table ,else if  none value are selected from the top table .......the bottom table should show either 0 or empty space


      to achieve the above task i wrote this expression ,unfortunately it throwing me an error




      if(GetSelectedCount(name1)>0,FirstSortedValue({<ROLE={'SELF_EVALUATOR'}>}QM_SCORE, -DATE_OF_REVIEW,0 )