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

# Percentage values not being displayed

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.

• ###### 1. Re: Percentage values not being displayed

Renato,

I think it will depend on how your data is arranged.

I think blank values will result If the the data looks like:

Date,Metric,Number

1/1/2016,ClosedSR,5

1/1/2016,Timely Closure,7

• ###### 2. Re: Percentage values not being displayed

Hi Swaroop,

Regards,

Renato

• ###### 3. Re: Percentage values not being displayed

Renato,

Because the Metrics are on different lines in your dataset, a division will produce

blanks because there isn't a Closed Metric and a Timely Metric on the same line.

Instead, I think you will need to use Level of Detail calculations.

An example of one would be something like:

{ FIXED [Market],[Date]:SUM(IF NOT(ISNULL([ClosedMetric])) THEN [Number] END)}

Which will associate the summed Number with every line for that Market on that Date.

Please see if the attached could be a first step for you.

• ###### 4. Re: Percentage values not being displayed

Thanks Swaroop. How do i get monthly values and YTD values. I see that you have added many fields to the rows. I just need the segment. Do i need to add the date and other items. The calculation has been Timely/Closed. I tried the same and do not get the correct values.

Regards,

Renato.

• ###### 5. Re: Percentage values not being displayed

Renato,

The other fields are not needed.

You should be able just calculate by month, for example.

Please see sheet 2 of the attached.