Trying to make this add together in reports

[Bob_be]

You will have to convert each report To Number (TN). The proper syntax is TN('<x>').

Your almost there. It should be:

[=F(TN(’{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) AND (TY=Food Drink Ticket) AND (MG=Starlight Bar) OR (TY=Bistro Food) AND (MG=Starlight Bar)}’)+TN(’{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) AND (TY=Bistro Staff Food) AND (MG=Starlight Bar)}’),‘0.00’)]

The ,‘0.00’ may or may not be necessary. Sometimes a calculation is done it will display the least amount of characters as possible. Meaning a number you want to read as 10.00 will be displayed as 10. The ,‘0.00’ will force it to display the .00…Or if the calculation is longer than 2 digits past (to the right) the decimal, it will force it to 2 places.

Here is the first link I could find about the F (Format) - the first 3 lines are the relevant ones:

Custom report arranged by Ticket Tag

You can format them as you want. Format syntax is… <positive format>;<negative format>;<zero format> So if you have #.00;-#.00;*zero* 0 value will appear as *zero*. If you have a ticket tag named People you can add it into report by adding TT.Person field as… [Tickets:1,1, 1,1, 1, 1] >Date|Ticket No|Amount|Cash|Credit Card {REPORT TICKET DETAILS: T.Date, T.TicketNumber, T.TotalAmount, TT.Person, PA.Cash, PA.Credit Card} Reading tutorials @Jesse linked will give more idea so once you get the…