5 Replies Latest reply on Apr 12, 2018 5:15 AM by Tushar More

# Calculated field for Percentage

Hi,

Find the case below.

Description :

We have a report with 3 charts and 5 filters.

In this dashboard the **cluster name filter** is not applied on the machine count worksheet. Rest all filters are applied on all the worksheets in the dashboard.

we have another calculation which is

calculating the percentage of all the clusters to the total machine count.

The formulas used are

numerator : countd(if [cluster name] <> "Not Clustered"

then

[Serial No]

END)

denominator

countd(

[Serial No]

)

percent

round(([numerator]/[denominator]) * 100,2)

Screenshot Attached for the same.

So if you refer to the above screenshot, when the filters value is changed for cluster name(say test cluster1) then percentage should be 4/21 = 19% but we are getting percentage as 100 %

So expected value is 19% but we aer getting 100 %

How do we make sure that the machine count should be fixed and calculation is 4/21= 19% in this case.

* Note : We tried to implement the above using LoD but did not get expected results.

• ###### 1. Re: Calculated field for Pe

Hi Mahesh,

Please find my approach as referenced below and stored in the attached workbook.

~Tushar

• ###### 2. Re: Calculated field for Pe

Now your solution is working for cluster name filter, but if i select values from any other filter. percentage is incorrect.

FYI: cluster name filter is not applicable on machine count but applicable on percent. please find the screenshot below.

Numerator calc should be same as we do not want Not clustered in calculation.

Numerator calculation :

countd(if [cluster name] <> "Not Clustered"

then

[Serial No]

END)

so, in below screenshot %age should be (test cluster 2 + test cluster 1) / machine count  (as we are not including "not clustered" in numerator)

(2+4/10)*100  = 60% but its showing 28.57

• ###### 4. Re: Calculated field for Percentage

Hi Tushar

Thanks for your Quick Reply. but i don't want to apply filter cluster name on machine count. as of now machine count is changing by applying cluster name filter.

Regards

Mahesh

Peace (V)

• ###### 5. Re: Calculated field for Percentage

You can turn it off.

~Tushar