stacked chart with vertical secondary axis series

• Nomvula

  Hall of Fame

  Points: 3775

  More actions

  March 22, 2017 at 4:18 am

  #321784

  Hi
  I have a stacked chart I need to calculate attainment percentage but i'm getting extra labels on the trend which are 0 %.
  the formula I used for the label is :

  CStr(((Sum(Fields!CompletedOnTime.Value) * 100) / CountDistinct(Fields!Code.Value,"Month_Year2"), 1)) + "%")
  if you look in the table these fields are OnTime/ Total Scheduled so the percentage on the graph should be the same as in the table. see the screenshot of my chart, the design and preview.