# Variance from total

**URL:** <https://pug.phocassoftware.com/t/variance-from-total/2490>\
**Category:** Ask the Community\
**Tags:** howto\
**Created:** [June 27, 2023, 5:32pm UTC](https://pug.phocassoftware.com/t/variance-from-total/2490 "2023-06-27T17:32:44Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![anon33838874](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon33838874](https://pug.phocassoftware.com/u/anon33838874)\
**Post date:** [July 3, 2023, 9:50pm UTC](https://pug.phocassoftware.com/t/variance-from-total/2490/7 "2023-07-03T21:50:12Z")

</div>

@JonKemp good point. Yes it would be possible by dropping into “nasty custom code”. However this functionality is not documented (see [Custom Mode](https://helpphocassoftware.atlassian.net/wiki/spaces/userdoc/pages/590045/Use+Custom+mode)) and its use has limited support.

I think the column expression would be something like:

`^((sum({b}) over()/sum({a}) over())*100)-(({b}/{a})*100)`

---

_[View the full topic](https://pug.phocassoftware.com/t/variance-from-total/2490)._