Forum Discussion
Why does this measure work?
Hi randyrettig - your measure should be as below:
%measure = DIVIDE([past due],([on time] + [past due]))This divides the past due count by the total count (on time + past due).
I tested with sample i got it 0.01 after that you have to multiple with 100 . When you format this as a percentage, it becomes 0.67%, which matches your expected result
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Hi randyrettig ,
Not sure if I got the essence of your error but looking at the measures you present both of them present the same value that is 0.01 (if rounded to 2 decimals) but be aware that since your values are very smal the measure look the same but they are not:
1/ 149 = 0.006711409
1 / (149 + 1) = 0.0066666
Believe that your problem is the lack of formatting has percentage this will give you the multiplication by 100 without writing it on the formula.
Hi randyrettig ,
Not sure if I got the essence of your error but looking at the measures you present both of them present the same value that is 0.01 (if rounded to 2 decimals) but be aware that since your values are very smal the measure look the same but they are not:
1/ 149 = 0.006711409
1 / (149 + 1) = 0.0066666
Believe that your problem is the lack of formatting has percentage this will give you the multiplication by 100 without writing it on the formula.