Math Operations to Custom Report

[mjb2000]

Good news - This should be easy to achieve using “Field Calculations”…

@emre

Field Calculations

This great feature allows you to make calculations by using field values.

Syntax: =<calculation>

Examples

{REPORT TICKET DETAILS:T.TicketNumber,T.Time,TN.TotalAmount,=2+2}

This tag displays the result of 2+2 on all lines.

{REPORT TICKET DETAILS:T.TicketNumber,T.Time,=[T.TotalAmount]*2}

This tag displays Ticket’s Total Amount multiplied by 2.

When you use fields in calculations you need to enclose them in square brackets. For example:

{REPORT TICKET DETAILS:T.TicketNumber,=[T.TotalAmount]*[EC.Employee.Comission]}

For more info, take a look here…

Custom Report Tags in detail

These are the supported DETAILS tags. {REPORT TICKET DETAILS:<fields>:<expression>} {REPORT ORDER DETAILS:<fields>:<expression>} {REPORT PAYMENT DETAILS:<fields>:<expression>} {REPORT CALCULATION DETAILS:<fields>:<expression>} {REPORT ENTITY STATE DETAILS:<fields>:<expression>} These tags are useful to create table reports. In this post I’ll explain how <fields> section works. This sample tag lists all tickets created by user named Emre {REPORT TICKET DETAILS:<fields>:(TU=Emre)} By using fi…