# How can i show 1.5% from total sales per work period for waiters i want to give them give them as commission as shown in my snapshot

**URL:** <https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459>\
**Category:** V5 Question\
**Created:** [November 30, 2017, 4:41pm UTC](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459 "2017-11-30T16:41:20Z")\
**Posts on this page:** 7\
**Page:** 2

<div class="post-metadata">

**Author:** ![tech2030](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/t/74df32/32.png) [@tech2030](https://forum.sambapos.com/u/tech2030)\
**Post date:** [December 2, 2017, 1:51pm UTC](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459/21 "2017-12-02T13:51:43Z")

</div>

Hi guys still not sorted anybody with the idea

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [December 2, 2017, 6:40pm UTC](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459/22 "2017-12-02T18:40:36Z")

</div>

Sorry again I was on my phone and spell checker kept changing symbols… this should work

`[=TN('{REPORT ORDER DETAILS:O.ExactTotal.Sum:(OU=$1)}')*0.015]`

I just tested it on my system and it appears to work

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [December 2, 2017, 6:46pm UTC](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459/23 "2017-12-02T18:46:10Z")

</div>

You can try something like this to format it pretty.

`[=F(TN('{REPORT ORDER DETAILS:O.ExactTotal.Sum:(OU=$1)}')*0.015,'$ 0.00')]`

 ![image](https://forum.sambapos.com/uploads/default/original/3X/b/b/bbc59c4ad22ae92d4a2ca6d0712fb9da41ef168d.png)

---

<div class="post-metadata">

**Author:** ![tech2030](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/t/74df32/32.png) [@tech2030](https://forum.sambapos.com/u/tech2030)\
**Post date:** [December 2, 2017, 6:51pm UTC](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459/24 "2017-12-02T18:51:26Z")

</div>

> [@Jesse](#):
>
> [=F(TN(‘{REPORT ORDER DETAILS:O.ExactTotal.Sum}’)\*0.015,‘$ 0.00’)]

great and awesome…one more thing is there a way we can now make it deduct commission from user total sales

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [December 2, 2017, 6:55pm UTC](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459/25 "2017-12-02T18:55:17Z")

</div>

You can do anything you want. Now that you see the syntax you can apply that to any report tag. You see what I did there? I used the format F and to number TN functions. I fancied it up at the end by formatting its output by using **,’$ 0.00’**

BTW Look again I edited it to make it user specific.

Your entire report becomes this:

```auto
[Sales by User:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.User:(ODI=True):,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1):{0}:,}
@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,}
>>{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum:(OU=$1)}
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1) and O.MenuItemName="$2"}
Commision 1.5% [=F(TN('{REPORT ORDER DETAILS:O.ExactTotal.Sum:(OU=$1)}')*0.015,'$ 0.00')]
{REPORT ORDER DETAILS:' '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1) and O.MenuItemName="$2":2}

```

 ![image](https://forum.sambapos.com/uploads/default/original/3X/1/d/1d8e194c64e8d8811c0c4b35c6fd4f3436dfaf3d.png)

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [December 2, 2017, 7:00pm UTC](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459/26 "2017-12-02T19:00:13Z")

</div>

Here is a great tutorial that shows these tricks

> [@Printer Template Formatting Tags](https://forum.sambapos.com/t/printer-template-formatting-tags/328):
>
> ##General \<T\> (Title) : When used it will format line as a title. \<F\> (Fill) : For example \<F\>- creates a line with - chars or \<F\>= creates a line with = chars. \<EB\> (Enable Bold) Prints everything Bold until \<DB\> command. \<DB\> (Disable Bold) Ends \<EB\> command \<Jxy\> (Justified) Justifies a line from pipe char. \<J00\>Total:|0.00 separates line from pipe (|) char. It aligns Total: part left and 0.00 part right. When used on a ESC/POS compatible ticket printer numeric parts sets font size. Fi…

---

<div class="post-metadata">

**Author:** ![tech2030](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/t/74df32/32.png) [@tech2030](https://forum.sambapos.com/u/tech2030)\
**Post date:** [December 2, 2017, 7:03pm UTC](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459/27 "2017-12-02T19:03:22Z")

</div>

> [@Jesse](#):
>
> [=F(TN(‘{REPORT ORDER DETAILS:O.ExactTotal.Sum:(OU=$1)}’)\*0.015,‘$ 0.00’)]

Thank you God Bless is Great

[Previous page](https://forum.sambapos.com/t/how-can-i-show-1-5-from-total-sales-per-work-period-for-waiters-i-want-to-give-them-give-them-as-commission-as-shown-in-my-snapshot/16459.md?page=1)