4 Replies Latest reply: Jan 23, 2015 7:38 AM by Gysbert Wassenaar RSS

    Change 'no data to display' error message if two expressions

      Hello,

       

      I understand the 'No data to display' error message can be changed by entering a chart expression into the 'Calculation Condition' field on a chart's General tab and then amending the error message associated with 'Calculation condition unfilled'.

       

      My chart uses two expressions. Would it be possible to achieve this by joining the two expressions, possibly with AND or OR?

       

      =if(GetSelectedCount(%Market)=1,sum([Actual Volume (HL) W+1])/MostRecentYear_TotalVol)

       

      =if(GetSelectedCount(%Market)=1,sum([TotalGM_perSKU])/MostRecentYear_TotalGM)

       

      Thanks for your help!

       

      Mel