This topic contains 2 replies, has 0 voices, and was last updated by michoel 7 years, 10 months ago.
-
Posts
-
samzad- Contributions: 0
- Level 1
- ☆
Hi Guys
A bit stuck on a transaction saved search – trying to show the invoice/transaction subtotal amount in the search result but not able to figure it out since no subtotal field is available in the search field drop down. Could use currency formula to calculate the value but search results are being used by a script to render to xml template and any formula in search breaks the templateRenderer api. Any pointer is appreciated
This is a cached copy. Click here to see the original post. -
OneITGuy- Contributions: 0
- Level 1
- ☆
Seems simple enough. GRRRR! Need this too.
-
michoel- Contributions: 0
- Level 1
- ☆
It looks like Amount (Net of Tax) (‘netamountnotax’) provides the subtotal amount.
With regards to the issue of the rendering a formula with XML templates, this should work as long as you only have one (of each type of) formula column in the search. Alternatively, you could include the individual columns in your search results and calculate the formula in Freemarker, or with SS2.0 you now have the option to calculate the results in your script and pass the results as a regular Javascript object.
You must be logged in to reply to this topic.