# How to filter negative records

**URL:** <https://community.spicecrm.io/t/how-to-filter-negative-records/787>\
**Category:** KReporter\
**Created:** [December 1, 2025, 4:45pm UTC](https://community.spicecrm.io/t/how-to-filter-negative-records/787 "2025-12-01T16:45:21Z")\
**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:** [December 1, 2025, 4:45pm UTC](https://community.spicecrm.io/t/how-to-filter-negative-records/787/1 "2025-12-01T16:45:21Z")

</div>

We have added custom row in kreport called Final Amount.

We are doing field1 - field2 to calculate amount for Final Amount column.

Now, we want to display only -negative values in the table. How to do it?

---

<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:18am UTC](https://community.spicecrm.io/t/how-to-filter-negative-records/787/2 "2025-12-02T09:18:23Z")

</div>

@rsp Here is an example:  
I am using Opportunities and I just created negative values by doing a -50000 on the field amount:

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/2438c638417fe201c0199b0f81b11f19d30aef90.png)

Then in the Filter Tab I use the same custom SQL. Caution: under Filter {f} will not be replaced by the field name. So write the field name directly

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/a252c8d3e5c8ede05574aea9b88f762ea14803f6.png)