In a Transaction Saved Search, for numeric fields like Amount, the Show Totals preference will not work when Summary Type is set to either Maximum or Minimum. To be able to display the totals on the results, use the formula: MAX({totalamount}) OR MIN({totalamount})
Tag: summary type
Results without Summary type Column in Search
Use the below formula to show the summary value without grouping the search results. count /*comment*/ ({memberitem.internalid}) over (partition by {internalid}) For Example:::Search Type: ItemItem Type: Kit/ PackageResults: Show the count of member items and member item quantity without using the summary type column under the Results subtab Output: Script Code: var kititemSearchObj = search.create({type:… Continue reading Results without Summary type Column in Search