Help with properly displaying percentage?

[Anonymous]

I have a formula that appears to be shooting out the right number just in a format I can't use. I am wanting to see the percentages of test scores above or equal to 4 and in the first quarter of 2018.

count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score)

Resulting in 186100%

How would I go about converting this to just a 2 digit percentage?

[MK_QSL]

Where are you using this?

you can use

Num(

count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score)

,'#,##0')

[Anonymous]

I am using it in an extension called "Simple KPI"

[yujiyamane]

If the percent is against test scores in the same period. It should be like below.

Num(count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score) /count({<Quarter={"Q1 2018"} >} test_score) ,'#,##0.00%')

If the percent is against the total count. It should be like below.

Num(count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score) /count( test_score) ,'#,##0.00%')

Hopefully this helps you.

Let me know if i can be of any more help.