REPORT TICKET DETAILS report

V5 Question
1

Can you Help me Pls

I want to this report

[User Sales:6, 6,6,6,6,6]

PersonelAdı|Toplam Satış|Kişi Sayısı|Sipariş Sayısı|Kişi Ortalaması|Sipariş Ortalaması
{REPORT TICKET DETAILS:T.User,T.TotalAmount.Sum,TTN.Kişi Sayısı.Sum,T.ItemCount.Sum,}

https://i.hizliresim.com/6yW0dW.jpg

2

Try
5: [=TN(‘T.TotalAmount.Sum’)/TN(‘TTN.Kişi Sayısı.Sum’)]
6: [=TN(‘T.TotalAmount.Sum’)/TN(‘T.ItemCount.Sum’)]

[=xxx] square brackets = is for calculation
TN(‘xxx’) forces value to number to make sure its not treated as a string in calculation

3

not work :frowning:

[User Sales:6, 6,6,6,6,6]

PersonelAdı|Toplam Satış|Kişi Sayısı|Sipariş Sayısı|Kişi Ortalaması|Sipariş Ortalaması
{REPORT TICKET DETAILS:T.User,T.TotalAmount.Sum,TTN.Kişi Sayısı.Sum,T.ItemCount.Sum,[=TN(‘T.TotalAmount.Sum’)/TN(‘TTN.Kişi Sayısı.Sum’)]}

https://i.hizliresim.com/o64o2R.jpg

4

OK, just looked at another post and its different in reports to automation, try this;

[T.TotalAmount.Sum]/[TTN.Kişi Sayısı.Sum]
[T.TotalAmount.Sum]/[T.ItemCount.Sum]

5

Yes Yes Yes… Working…

Thank you so much

Teşekkür Ederim (turkish) :slight_smile:

6

Thankl you…

Can you help me

{REPORT TICKET COUNT: for user total

7

Try something like this;

[User Tickets:1,1]
>User|Ticket Count
@{REPORT TICKET DETAILS:T.User.asc}
$1|{REPORT TICKET COUNT:(TU=$1)}

@ delairs a list using the report following it
$1 then loops the list values giving you a line per value of the @ list

8

Not Work

I want to
TEKNO = 3 ticket count
KASA = 1 ticket count

https://i.hizliresim.com/2EzBdE.jpg

9

Try this;
I only have one user for current period tickets so maybe it needed the comma seperator. But then again the $1’s render ok…

[User Tickets:1,1]
>User|Ticket Count
@{REPORT TICKET DETAILS:T.User.asc::{0}:,}
$1|{REPORT TICKET COUNT:(TU=$1)}

Works for me, must have been that;

image
image.png1705×547 22.5 KB

11

thank you … working

you have my last request

https://i.hizliresim.com/rJzrBN.jpg

@JTRTech

12

Where do you want that?

13

https://i.hizliresim.com/POJ9oO.jpg

@JTRTech

14

FYI, stop @ tagging, it doesnt get you answer any quicker, already get notification when you reply…

Try this;

[User Tickets:1,1,1]
>User|Ticket Count
@{REPORT TICKET DETAILS:T.User.asc::{0}:,}
$1|{REPORT TICKET COUNT:(TU=$1)}|[=TN('{REPORT TICKET DETAILS:T.TotalAmount.Sum:(TU=$1)}')/TN('{REPORT TICKET COUNT:(TU=$1)}')]
15

I am so so sorry

Thank you… working…

I happy man … Thank you

16

this report is great!!, just one thing how can i format the value to ###.###

Captura
Captura.PNG1365×719 38.2 KB

17

Wrap the value in a F expression a bit like this;

[=F(TN('{REPORT EXPRESSION}')/TN('{REPORT EXPRESSION}'),'0.000')]

18

sorry im a little bit rusty with that expression, can u give some tip please.

[Ventas Usuarios:1,1,1]
>User|Numero de Tickets|Valor
@{REPORT TICKET DETAILS:T.User.asc::{0}:,}
$1|{REPORT TICKET COUNT:(TU=$1)}|[=TN('{REPORT TICKET DETAILS:T.TotalAmount.Sum:(TU=$1)}')/TN('{REPORT TICKET COUNT:(TU=$1)}')]
19

[=TN('{REPORT TICKET DETAILS:T.TotalAmount.Sum:(TU=$1)}')/TN('{REPORT TICKET COUNT:(TU=$1)}')]

becomes

[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.Sum:(TU=$1)}')/TN('{REPORT TICKET COUNT:(TU=$1)}'),'0.000')]

20

almost! it should be 18.000 and 133.000 no 18000.000 and 133000.000
Captura1

21

Points vs commas are defined by regional settings.
That formatting wouldn’t change the actual number so you have other issue.