Problem with merge text field
I have a merged text field that contains calculations. It displays the top seling product and is in the footer in a layout report:
TOP PRODUCT <<PRODUCT>> <<max COMMISSION>> (<<max QUANTITY>>)
The problem is when the layout is active, and if I click on any summary in the body of the layout, the merged text field displays the data that is associated with what was clicked, instead of always displaying the top selling product. So I have to scroll to the top product and click on it to get the correct data to display. If I don't click the layout, the data is accurate.
I have tried to fix this, but have not been successful. Can anyone please help me? Thanks in advance.