8 Replies Latest reply: Jan 28, 2016 5:20 AM by V SUDHAKAR RSS

    getting zero target to show in chart

    Rhona Corcoran

      Hi

       

      I have a chart with data showing for areas compared to a target.  this works fine except when the target is 0 then the target line does not show up.

       

      The target is written as an expression as follows:

       

      if(ReferredYYYY=2016, Sum({$<[TargetCode]={"MH39"},ReferredYYYY, TargetYearMonth={">=$(=AddMonths(Max({<[CAMHS121] ={7}>}YearMonth), -12))<=$(=Max({<[CAMHS121] ={7}>}YearMonth))"}>}Target) ,

      if(ReferredYYYY=2015, Sum({$<[TargetCode]={"MH-39"},ReferredYYYY, TargetYearMonth={">=$(=AddMonths(Max({<[CAMHS121] ={7}>}YearMonth), -12))<=$(=Max({<[CAMHS121] ={7}>}YearMonth))"}>}Target) ,

      if(ReferredYYYY=2014, '',

      if(ReferredYYYY=2013, ''))))

       

      can anyone help as to how I can make the target show if zero.

       

      Thanks