5 Replies Latest reply on Jun 3, 2016 7:19 PM by swaroop.gantela

    Percentage values not being displayed

    Renato Lyke

      Hi,

      I have two measures that are calculating the sums of particular values then i am dividing them and adding it to display values i get blank values. Below are the metrics.

       

      Closed Measure:

      IF[Metric]= "Closed Notices" OR [Metric] = "Closed SR's" THEN IF

      (

      [Date]<=today() AND MONTH(today())>=7 AND YEAR(today())=YEAR([Date])

      AND MONTH([Date])>=7

      )

      OR

      (

      [Date]<=today() AND MONTH(today())<7 AND

      (

      YEAR(today())=YEAR([Date]) AND MONTH([Date])<7

      OR

      YEAR(today())-1=YEAR([Date]) AND MONTH([Date])>=7

      )

      )

      THEN [Number] END

      END

       

      Timely Closed Measure.

       

      IF [Metric] = "Timely Closure" THEN IF

      (

      [Date]<=today() AND MONTH(today())>=7 AND YEAR(today())=YEAR([Date])

      AND MONTH([Date])>=7

      )

      OR

      (

      [Date]<=today() AND MONTH(today())<7 AND

      (

      YEAR(today())=YEAR([Date]) AND MONTH([Date])<7

      OR

      YEAR(today())-1=YEAR([Date]) AND MONTH([Date])>=7

      )

      )

      THEN [Number] END

      END

       

      Any suggestions how do i display the values.

       

      Regards,

      Renato.