# Issue with ratio between two measures

**URL:** <https://community.holistics.io/t/issue-with-ratio-between-two-measures/832>\
**Category:** Ask the Community\
**Created:** [March 23, 2022, 9:00pm UTC](https://community.holistics.io/t/issue-with-ratio-between-two-measures/832 "2022-03-23T21:00:24Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Khai\_To](https://community.holistics.io/user_avatar/community.holistics.io/khai_to/32/128_2.png) [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Post date:** [June 1, 2023, 9:11am UTC](https://community.holistics.io/t/issue-with-ratio-between-two-measures/832/9 "2023-06-01T09:11:22Z")

</div>

Hi @dacou, @DataGeekDude, and @Martin_Dell,

We are working on a new Expression to support this use case so that you don’t have to write complex SQL Models for it.

For more information, you can refer to the thread below

> [@\[🚀 Launched\] Our brand new Analytics Query Language, AQL!](https://community2.holistics.io/t/upcoming-our-brand-new-analytics-query-language-aql/1533/2):
>
> Do note that we are currently in the development phase, exploring various solutions, which may result in changes to syntax and UI in the future Sub-group Calculation With AQL Expression, you can perform Subgroup Calculation flexibly and easily without having to create SQL (or transform) Model. You can refer to the video below for more information. Sample syntax sum(order\_items.quantity) \* 1.0 / eval(sum(order\_items.quantity), exclude(users.age\_group)) If you have any questions…

---

_[View the full topic](https://community.holistics.io/t/issue-with-ratio-between-two-measures/832)._