# Will cross model expression be enabled in the near future? **URL:** \ **Category:** Feature Suggestions\ **Created:** [November 1, 2022, 5:51pm UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273 "2022-11-01T17:51:49Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![michael.mccann](https://community.holistics.io/user_avatar/community.holistics.io/michael.mccann/32/668_2.png) [@michael.mccann](https://community.holistics.io/u/michael.mccann)\ **Post date:** [November 1, 2022, 5:51pm UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/1 "2022-11-01T17:51:49Z")
Hi all, Will cross model expression be enabled in the near future? It could be a really useful feature. It’s not a huge issue but a few times I’ve had to edit underlying data tables in order to get the reporting I want. It ends up occasionally being an extra consideration when doing the data modelling. ![image](https://community.holistics.io/uploads/default/original/1X/f687ec168f0d445ea540a0a26de3fe47a9809519.png) ---
**Author:** ![DataGeekDude](https://community.holistics.io/user_avatar/community.holistics.io/datageekdude/32/430_2.png) [@DataGeekDude](https://community.holistics.io/u/DataGeekDude)\ **Post date:** [November 2, 2022, 10:49am UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/2 "2022-11-02T10:49:43Z")
I was under the impression that this type of business calculation was allowed and they way to get round the inability to create a dimension or measure in AML? ---
**Author:** ![daph.td](https://community.holistics.io/user_avatar/community.holistics.io/daph.td/32/811_2.png) [@daph.td](https://community.holistics.io/u/daph.td)\ **Post date:** [November 3, 2022, 3:45pm UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/3 "2022-11-03T15:45:10Z")
Hi Michael, The short answer is **YES! - We are in the midst of our plan to drastically improve Holistics Expression and Cross-model Expression is a critical part of the plan**. At the moment, we are totally aware that “Business calculation” has room for improvements, which might cause troubles to your workload as you mentioned. “Business calculation”, for now, only supports Cross-model Expression when the children components are aggregated, e.g. - **support** : sum(model\_a.field\_a) + sum(model\_b.field\_b)) - **does not support** : sum(model\_a.field\_a + model\_b.field\_b)) We are trying our best to push the cross-model expression to our users. I hope you understand and bear with us for a while. Thank you so much! Daphne ---
**Author:** ![michael.mccann](https://community.holistics.io/user_avatar/community.holistics.io/michael.mccann/32/668_2.png) [@michael.mccann](https://community.holistics.io/u/michael.mccann)\ **Post date:** [November 16, 2022, 9:36am UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/4 "2022-11-16T09:36:34Z")
thanks Daphne! looking forward to this ---
**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:25am UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/5 "2023-06-01T09:25:13Z")
Hi @michael.mccann and @DataGeekDude, We just had an official announcement for Cross-model Calculation. You could follow to the Community Post below for more information regarding progress and update. > [@\[🚀 Launched\] Our brand new Analytics Query Language, AQL!](https://community2.holistics.io/t/upcoming-our-brand-new-analytics-query-language-aql/1533/3): > > 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 Cross-model Calculation Let’s say you are a Country Manager of an Ecommerce Company and you want to calculate the Revenue by Country. The formula to calculate it is the sum of the product price (from the Product model) multiplied by the quantity (from the Order Items model). order\_items | sum(order\_items.quantity \* products.price) They are from 2 di… ---
**Author:** ![michael.mccann](https://community.holistics.io/user_avatar/community.holistics.io/michael.mccann/32/668_2.png) [@michael.mccann](https://community.holistics.io/u/michael.mccann)\ **Post date:** [March 26, 2024, 5:39pm UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/6 "2024-03-26T17:39:30Z")
hi @Khai_To , have you guys made any progress on this? It feels like a very basic feature that is missing and incentivises me to create data models not using best practices just because i can’t create simple charts with holistics using the fact / dimension approach. ---
**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:** [March 27, 2024, 3:09am UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/7 "2024-03-27T03:09:44Z")
Hi @michael.mccann, Cross-model calculation has officially been supported via our AQL Expression. You can refer to our post [here](https://community2.holistics.io/t/upcoming-our-brand-new-analytics-query-language-aql/1533/3) for more information. However, do note that our AQL Expression is only supported in version 4.0 so if you’re in version 3.0, you would need to [migrate to version 4.0](https://docs.holistics.io/as-code/3.0-to-4.0-migration). Do let me know if you have any questions or concerns. ---
**Author:** ![olammas](https://community.holistics.io/user_avatar/community.holistics.io/olammas/32/1213_2.png) [@olammas](https://community.holistics.io/u/olammas)\ **Post date:** [March 27, 2024, 3:45pm UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/8 "2024-03-27T15:45:33Z")
Hi Khai, I noticed that cross model AQL doesn’t work when trying to do a rolling average when using the `trailing()` function? Is this a known bug? ---
**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:** [March 28, 2024, 4:17am UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/9 "2024-03-28T04:17:25Z")
Hi @olammas, Could you share more details about the error that you’re encountering? You can send the screenshot and the link to your report via our support ticket so that we can investigate further. I have also created an example using our [AMQL Playground here](https://play.amql.org/#code/uDritRdcsbtfekV2DrisS2OsH2FriisE2HtljVijsGtdfUVcsGxiDxWDslxMErgxYF22tMe27tkuBtgVsSrgntkRScVrnxREtc2K2ixSDtFxkExSF2ytjTiZgkZ3kxYDxTGtR2xtPjfliTVPe3dyFE2m3rxcFtfne26xRHsYtYfcZj26tT4M3BxeFysFx0ItMrixlE2GsG2DzZF2HxkDyjFtZ2gtejy0DrgtZUzuGzfKshtUyMF0EJteld2ZtixUHtY2w3WztDtWRc3UxTG0ITxVEtWZeZxUGsYtjh6fuDDrgjtDsntFCsbd4w32uFFsTTxpEuFzVQ2FtXePlgP1NDtVzfQtDxcDrgtFgrgscxcDzpOxuEzn9znOzLNzxh2lzvYsZtkztS313Dzx9zxWzLDzvZ3BtijkPeR2QzvQsexaErgxaEzvO4tuA0EIzr9zrHzHLzrZ4ZzqXskxZDzp9zplzFKzoZtVdRZx0DzkOsdxVEzg9zggy6GzcZtSZikYPUR35zhQsaxaE2qxaDzmOxSLzm9zmHzHLzrZtX2I3GtiznQsfxWFzjO3JuAtkzj9zjOy8HzfZtT24uBtP3rzgQsbxXDrg2XzhOteld2ez1Izj9zjHzDIzkZtWlccPeR2PzmQsexZDrgxZEzoOtkVuAtkzm9zmOzFKzoNuFrisErisHtfi26tijsGtdf2HtcsG2jtcrisSrislxMErgxZGz3GzdI48tczwG0JIsnxlFxTFzcTtUR2ytPjfliTVzFFxYD2m3txcFtfne26xRHsYtYfcZj26tT4O3BxeFytFx0ItMrixlE2GsG2DzbG2IxlDykFtZ2htejy1Drg6yzwGzhKshtU1mH0GHteld2ZtixUHtY2w3MzuDtWRcjVxTG0JTxVEtWZeZxUGsYtjh6iuDDrgjtDsntFCsbd4x32uFFsTTxpEuFzVQ5W6HtljzZQtDxWFzdOtkVuAtkzb9zbOy8HzfZ3RtV2htVUP2FzjQsbxaGrgsZzVIznHtUxWD3v3Dzr9zrOzLLzvZ5OtViP3vzsQtFxXDrgshtUzpOteld2etizn9znOzDIzkZ2K3Vtfle5JzlPscxYHzm9zmizFJzna4VtZm33uBtPRkkVdgjzvRxgHrgsZxgGz39z3jzVQ0CNuFrisErisHtT2btVXf3Z3esGtdfxwDsGtRdcrisSrislxMErgxdK0SGzuHtk5XtcVzFF0hIsbxpJxXFzvTtU2itRPjfliTVPe3nyKE2m31xcFtfne4rxRHsYtYf46tj26tT4W3BxeFyxFx0ItMrixlE2GsG2DzjK2MxpDyoFtZ2ltejy5DrgtZUz4GzpKshtUyRF0OJteld2ZtixUHtY2w3bzyDtWRcjVxTG0NTxVEtWZeZxUGsYtjh6uuDDrgjtDsntFCsbd4132uFFsTTxpEuFzVQ0HEzXQsmxUDzZO5ZuAtkzX9zXOy4FzZZtgRi2KtkP11StAxZFrg189zlkzHKzqNuFrisErisHtTx0D3TsGtdf3EtcsG5QtcrisSrislxMErgxZGz5GzfHtk5BtcVyzF0LIsbxlFxTFzcTtUR2ytPjfliTVP1vExYD2m3txcFtfne5txRHsYtYfcZj26tT4O3BxeFytFx0ItMrixlE2GsG2DzbG2IxlDykFtZ2htejy1Drg0lDzwFzhKshtU1mH0GHteld2ZtixUHtY2w3XzuDtWRcjVxTG0JTxVEtWZey3DxUEsYtjh6iuDDrgjtDsntFCsbd4x32uFFsTTxpEuFzVQ0DEzXQsmxUDzZOtkVuAtkzX9zXOy4FzZZtTflekiuBtP2I3HzhQsbxcGrg2I2czp9zpgzLNzxNuFrisErisHxfGtZ3ZsGtdxhDtcsG5atcrisSrislxME0JHxcD0GGzmI5Ltcz5G0VOxoDxWFzoTtUR21tPj2mtiTVPe3lyJE2m3zxcFtfneVixRHsYtYfcZj26tT4U3BxeFywFx0ItMrixlE2GsG2DzhJ2LxoDynFtZ2ktejy4D0AD0zDz4FzpM2U15H0QItVuAtkxSHtYZU2ezzDtWRcjVxTG0OTxVEtWZeZxUGsYtjh6tuDDrgjtDsntFCsbdGy4FuFFsTTxrEuFzZQ0KEzZQsmxUDzZ9zZgy4FzZZ43te23te2NtkPzjU68xeHrgzt9ztkzPPz3NuFrisErisH2VtiTYR2gtjsGtdf3MtcsG2mtcrisSrislxMErgxcJ0KGzoI5Ptcz7G0ZIslxoIxWFzqTtUR21tPjfl2ntVzOFxYD2m3zxcFtfn4ltixRHsYtYfcZj26tT4U3BxeFywFx0ItMrixlE2GsG2DzhJ2LxoDynFtZ2Utejy4DrgtZUz2GznKshtU13H0MHteld2ZtixUHtY2w3azxDtWRcjVxTG0MTxVEtWZeZxUGsYtjh6ruDDrgjtDsntFCsbd4032uFFsTTxpEuFzVQ0GEzXQsmxUDzZOtkVuAtkzX9zXOy4FzZZtT22uBtP1zSsbxXDrg149zhkzDIzkNuFrisErisHtfi24ti2b6XtdjsGtdf2MtcsG5PtcrisSrislxMErgxeL0CGznHtk5HtcVy7F0RIsnxqKxYFzpTtUR23tPjfliTVP14ExYD2m33xcFtfne3CxRHsYtYfcZj26tT4Y3BxeFyyFx0ItMrixlE2GsG2DzlL2NxqDypFtZ2mtejy6Drgtgi5NtlTk1EE0FFzzKtAxaGrgshtUyiF0gJteld2htixUHtY243h0GDtWRcjVxTG0eTxVEtWZe4KxUFsYtjhc3wuDrgjtDsntFCsbdGzJLuFFsTTxxEuFztQ0OHzrRsnxYEzp9zplzFJznZthlRe284GznQtBxYHzn9znizFJznNuFrisErisHtgifUlTkjsGtd2I4ZsGtRdcrisSrislxMErgxbIz7GziHtk5DtcVy2F0NItAxnHxVFzhTtUR20tPjfliTVPe3jyIE2m3xxcFtfne5yxRHsYtYfcZj26tT4S3BxeFyvFx0ItMrixlE2GsG2DzfI2KxnDymFtZ2jtejy3Drg65z0GzlKshtU1tH0KHteld2ZtixUHtY2w3ZzwDtWRcjVxTG0LTxVEtWZeZxUGsYtjh6ouDDrgjtDsntFCsbd4z32uFFsTTxpEuFzVQtT6ItVXfiuBtPzeSsbxbHrgzn9znkzLMzwZteR2KzpQsmxUDziO3MuAtkzg9zgOy4FzZZ2ItiTYRek0BEzgPslxbHrgshtUznOteld2itizp9zpOzLMzwZtg3WtT5SzqPtAxVEzk9zkiy8GzeZ3QtVRkVUP2FzjQsbxaGrgsZtkzoOtUxWD3u3Dzq9zqOzLLzvNuFrisErisH2c4Yx3Etj3ttgjsGtRdcrisSritCxULydDtdfPTflek344AxKD2RtPxUGyyDxRFxbEuBxZF0uG0THtdRe2Wtk2o3L0WGtWifd2Xse20tcU3ktW1cI3M231cEyRG0XH5VxlDxVEyfLxbF0BDyjDtfyKbzvIyNRyFK1JF0tStg4mtUlTk5btZ63xRFtfi2Hti2Otk2M2UxdHxcD0t7yULzlPyiK0wmzyIyKPyCK0tXzIF0rWxMH0p90pZygI0nmzsG0lwtlj0kR2PxVE0e9zTWyaH0YmzfF0XwtTZ2QtV0YK0mGxVD5D0X9zSUyZH0WmzeG0XarisErisHtU5VtR3rtksGtRdcrisSriscxOG0gGtVT4ktd4JtTVybGxqEtPjflxRDtPe2v0ZExnEyRDxeEy3Ftj2UtLyxGzBGsExNH21tekixQKtfi2sti5Ptk3BxSNxNItg6itUlTkxPI1TFxLEtNytGti3r4QtZfejYZgy0KxWMsA0IFy5JxKD2RtPxUGzdFxbHuBxZFsErg2KtlVsBywHyKSzUI42tUyHG0HLxdIxcDyKg0rGyIVxMHyGh1VFyFO2PxVEx8j1FHyAIyOGxVD6Qx8Jx7EtN2FuFrisErisHtmxfDyDDsGtRdcrisSri6z3NtkrgsZlktPGsdtCDshnmrgsVrgnsKGIrniuF2stRhcsb2g5S2DxqDtVuAtgc4ftVrguDyQEtUZd2WyKEtjxQG2B17HtjsGtT2k4ntV4T2FrguE2otRuBsAzEFuFxFE20tRjl2fx0J1wEtPmRc4osSrgxSG2B1IF5DxaD2nxUI3L23tdsAxaLsGthlR4b0sDrgsCy8K2JtZT1zJ6DtRZcZeXyceyeux3NykItPg266UtUsA1MTsE5q3N2e0qDsAL1WEtjsBzkItdfmx7EtRmzmLsAyhKzxWzz5z16yHI3RsHrgsLxNEuF2FuFrisEritVuAtgc4NtVsc21tRjVksmtRdVrisSri4c5gtPVTfd2Oti4HxmDtTli2k3Wse38tVA2qtYxjDsH3axyFsG2ytcriuF) and it seems to work as expected from our side. ![image](https://community.holistics.io/uploads/default/original/2X/2/21c2293945d7f37e7a08b5f71cf9e99687c6eea2.png) ---
**Author:** ![olammas](https://community.holistics.io/user_avatar/community.holistics.io/olammas/32/1213_2.png) [@olammas](https://community.holistics.io/u/olammas)\ **Post date:** [March 28, 2024, 5:16pm UTC](https://community.holistics.io/t/will-cross-model-expression-be-enabled-in-the-near-future/1273/10 "2024-03-28T17:16:17Z")
Looks good. I’ll do some testing and flag to support. Thanks!! 🙂