3 Replies Latest reply: Mar 13, 2018 7:17 PM by Yuji Yamane RSS

    Help with properly displaying percentage?

    Jordan Hertl

      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?