# Tip - Display variance less than 1.00%

**URL:** <https://pug.phocassoftware.com/t/tip-display-variance-less-than-1-00/905>\
**Category:** Ask the Community\
**Created:** [February 13, 2019, 4:48pm UTC](https://pug.phocassoftware.com/t/tip-display-variance-less-than-1-00/905 "2019-02-13T16:48:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsavage16](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/rsavage16/32/392_2.png) [@rsavage16](https://pug.phocassoftware.com/u/rsavage16)\
**Post date:** [February 13, 2019, 4:48pm UTC](https://pug.phocassoftware.com/t/tip-display-variance-less-than-1-00/905/1 "2019-02-13T16:48:37Z")

</div>

Our quality metrics require us to show variances less than 1%. Phocas doesn’t do this on its own., we kept getting zeros. With some help from our consultant and support we came up with a solution. We had to create a custom column with the following formula.

((a_1.00/b_1.00)\*100