Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Where are you using this?
you can use
Num(
count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score)
,'#,##0')
I am using it in an extension called "Simple KPI"
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.