# How to apply amount difference condition

**URL:** <https://community.spicecrm.io/t/how-to-apply-amount-difference-condition/786>\
**Category:** KReporter\
**Created:** [November 26, 2025, 5:55pm UTC](https://community.spicecrm.io/t/how-to-apply-amount-difference-condition/786 "2025-11-26T17:55:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsp](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@rsp](https://community.spicecrm.io/u/rsp)\
**Post date:** [November 26, 2025, 5:55pm UTC](https://community.spicecrm.io/t/how-to-apply-amount-difference-condition/786/1 "2025-11-26T17:55:17Z")

</div>

@maretval

How can we use amount difference condition in the report.

For example, we have amount1 and amount 2. We want to display records where amount1 \< amount2.

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [December 2, 2025, 9:21am UTC](https://community.spicecrm.io/t/how-to-apply-amount-difference-condition/786/2 "2025-12-02T09:21:05Z")

</div>

@rsp use the same as in [How to filter negative records](https://community.spicecrm.io/t/how-to-filter-negative-records/787)

If amount1 - amount2 is less than 0 then it means that amount 1 \< amount2