1 Reply Latest reply on Apr 1, 2016 6:38 AM by Takaaki Koseki

# Help with Calculated field for Ratio using Dimension

Hello,

I have three dimensions in my data source which are Date, Status and Task ID. There are thousands of Task IDs which are in one of the Closed, New or Re-Open statuses. Now I am trying to create a calculated field called Close Ratio, the formula for this is:

Number of Task IDs in Closed Status/(Number of Task IDs in New Status + Number of Task IDs in Re-Open Status)

I tried creating some calculated fields but nothing are fetching required results. Some of them are:

1.

Closed Claims:

If ATTR([Status]) = "Closed" then COUNT([Task ID])

END

Created two more calculated fields for New and Re-Open statuses and created one more calculated field, which is defined as ([Closed Claims])/(([New Claims]) + ([Re-Open Claims]))

2.

Closed Claims:

If [Status] = "Closed" then 1 else o

END

Created two more calculated fields for New and Re-Open statuses and created one more calculated field, which is defined as ([Closed Claims])/(([New Claims]) + ([Re-Open Claims]))

Dragged this calculated field to columns shelf and dragged Task ID dimension to measures shelf, but of no use.

Need  help with this.

Best

Raj

• ###### 1. Re: Help with Calculated field for Ratio using Dimension

Hi.

As far as I see your information, 2nd one needs to be a little bit change like below.

SUM([Closed Claims])/(SUM([New Claims]) + SUM([Re-Open Claims]))

Original one would be calculated like below.

SUM( ([Closed Claims])/(([New Claims]) + ([Re-Open Claims])) )

Thanks.