
Hi
I have bee trying to create a Word Template for Quote. There are 4 different Product Categories [CAMS, GENIT, PHONES&NET and AXEZE].
Our requirement is to have 4 Different Tables for all 4 Categories. I created fields for all 4 categories and added the business rules but the Result is a bit different as shown in the Screen Shots. But I am not able to get the "Total Amount for each column" it only shows the Total Amount of Entire Quote.
Or is there any other way that I can do this with using Javascript or any other Code that can remove the blank spaces as well.
Hi Business Application,
Please try to create rollup fields to calculate each Product Category's total amount(such as CAMS_totalamount). And then use this field instead of totalamount in your template.