Auto calculate sum of just 2 payment types or more on report ticket

zaka360 · November 30, 2016, 2:45am

hi could anyone help me with this so im trying to get the sum of 2 separate payment types to show on my report tickets

Jesse · November 30, 2016, 2:47am

Show us your report syntax? Where in the report do you want it to show?

zaka360 · November 30, 2016, 2:56am

Jesse · November 30, 2016, 2:56am

I mean show a mockup of how you want it to actually look.

zaka360 · November 30, 2016, 3:01am

?? you mean first pic but then altered to how it should look or second pic with line added where the calculation should be?? srry didnt have much sleep last couple of days brain working very slow atm

Jesse · November 30, 2016, 3:02am

I mean your actual report when its generated… how do you want it to look.

Here is an example of a field calculation in custom reports.

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

That report is multiplying T.TotalAmount and EC.Employee.Comission

You would need to add an expression at end to filter it to those 2 payment types only though. If you use expression You may not need field calculation… let me see…

zaka360 · November 30, 2016, 3:16am

thats basicly the prob dont know how start

basicly i need the way of how to describe those 2 lines

Jesse · November 30, 2016, 3:19am

Ok I got it for you… Try this:

{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0 && Payment.Name.Contains("espece") OR Payment.Name.Contains("bouteille espece")}

You will need to manually name that… so you might try something like

Combined BLAH|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0 && Payment.Name.Contains("espece") OR Payment.Name.Contains("bouteille espece")}

zaka360 · November 30, 2016, 3:29am

so tried
>Espece|{REPORT PAYMENT DETAILS:P.Type,P.Amount.Sum:Payment.Amount > 0 && Payment.Name.Contains("espece") OR Payment.Name.Contains("bouteille espece")}

and it shows Espece but after that nothing

Jesse · November 30, 2016, 3:36am

Take P.Type out I changed it since. Also make sure those are correct payment types…I could have misspelled it.

zaka360 · November 30, 2016, 3:46am

still same thing it shows the BLAH part but after that still nothing checked and its written correctly

Jesse · November 30, 2016, 3:47am

Show me your actual report syntax now.

zaka360 · November 30, 2016, 3:48am

[Payments:2, 1, 2]
{REPORT PAYMENT DETAILS:P.Type,P.Amount.Percent,P.Amount.Sum:Payment.Amount > 0}
>Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}
>Espece|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0 && Payment.Name.Contains("espece") OR Payment.Name.Contains("bouteille espece")}

Jesse · November 30, 2016, 3:49am

Try this:

[Payments:2, 1, 2]
{REPORT PAYMENT DETAILS:P.Type,P.Amount.Percent,P.Amount.Sum:Payment.Amount > 0}
>Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}
>>Espece|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0 && Payment.Name.Contains("espece") OR Payment.Name.Contains("bouteille espece")}

zaka360 · November 30, 2016, 3:54am

still no luck it just changed it to lighter grey

Jesse · November 30, 2016, 3:54am

It definitely works… something is wrong. Is that the correct spelling of both payment types? No special characters or extra spaces at end by accident?

I just tested it I know it works.

zaka360 · November 30, 2016, 4:03am

checked it and i even copy pasted it but still no luck

Jesse · November 30, 2016, 4:05am

I dunno man it clearly works… You can see I used exact same syntax in mine except I put 2 of my payment types and it worked just fine.

here is a screenshot with 3 payment types used but only summing 2 lines.

zaka360 · November 30, 2016, 4:06am

could it be that it used the account name to do your calculation

Jesse · November 30, 2016, 4:07am

It didnt… but just to ease your mind here ya go.