# Compare two fields in reports/data source?

**URL:** <https://www.dynamicsuser.net/t/compare-two-fields-in-reports-data-source/15001>\
**Category:** Developer Forum\
**Created:** [January 14, 2004, 1:54am UTC](https://www.dynamicsuser.net/t/compare-two-fields-in-reports-data-source/15001 "2004-01-14T01:54:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hua](https://avatars.discourse-cdn.com/v4/letter/h/cdc98d/32.png) [@hua](https://www.dynamicsuser.net/u/hua)\
**Post date:** [January 14, 2004, 1:54am UTC](https://www.dynamicsuser.net/t/compare-two-fields-in-reports-data-source/15001/1 "2004-01-14T01:54:26Z")

</div>

How can I Compare two fields in reports/data source/query/datasource? Assume there is a table contains the following data: salesID salesQTY ConsignedQTY 001 100 90 002 200 200 Now, I want to create report in AXAPTA, I interesting the outstanding sales order record(s) that consignedQTY\<salesQTY. But where can I add my compare formula?Ranges? or overwrite some methods? But In ranges, I only can filter a field. Has anyone come across this issue? And could you give me some advice? Thanks in advance. Andy.Peng Qing Hua.

---

<div class="post-metadata">

**Author:** ![amar004](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@amar004](https://www.dynamicsuser.net/u/amar004)\
**Post date:** [January 16, 2004, 6:43am UTC](https://www.dynamicsuser.net/t/compare-two-fields-in-reports-data-source/15001/2 "2004-01-16T06:43:43Z")

</div>

Hi, You can apply the condition in the execetesection() of the body . i hope this will help you. Regards Amar

---

<div class="post-metadata">

**Author:** ![hua](https://avatars.discourse-cdn.com/v4/letter/h/cdc98d/32.png) [@hua](https://www.dynamicsuser.net/u/hua)\
**Post date:** [January 16, 2004, 9:52am UTC](https://www.dynamicsuser.net/t/compare-two-fields-in-reports-data-source/15001/3 "2004-01-16T09:52:51Z")

</div>

HI, Amar Senapati Thank you very much,it realy work! Andy.