# How to sum using a Join In a report

**URL:** <https://forum.inductiveautomation.com/t/how-to-sum-using-a-join-in-a-report/40029>\
**Category:** Ignition\
**Created:** [October 26, 2020, 6:54pm UTC](https://forum.inductiveautomation.com/t/how-to-sum-using-a-join-in-a-report/40029 "2020-10-26T18:54:13Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 27, 2020, 11:23am UTC](https://forum.inductiveautomation.com/t/how-to-sum-using-a-join-in-a-report/40029/3 "2020-10-27T11:23:21Z")

</div>

> [@WillMT10](#):
>
> Meaning your start and end for the BETWEEN check is identical.

Actually, no. That construct is common in T-SQL for truncating datetime to date.

---

_[View the full topic](https://forum.inductiveautomation.com/t/how-to-sum-using-a-join-in-a-report/40029)._