# 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

hi its doing the calculation for the first user because 400 but a figure more than 1000 or 2000 its taking the first number i.e 1 as the percentage and 2 what could be the issue
check the following code pls

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

The first user is okay coz its not more than thousand

Can you please show the part of report that is wrong?

The report suppose to generate 1.5 % commission of each user total sales as show but instead of calculating 1.5 % 9670 its giving 9 but the first one 960 is ok but when the value increases it gives the first number

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

I mean show the report with the error the result so I can see what it is doing. I have no clue what you mean by

That looks correct I can’t see what’s wrong. The math looks good it’s obviously not showing decimals you need to change it to show decimals if that’s what you mean. But that math is right.

Not ok because 1.5% of 9570 is not 9 and also 1.5% 1310 is not 1 but the first one 960 was ok 14.1 but when it changes to 4 digits its giving the first digit

Try this

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

its blank no value at the commission part

Sorry I meant this [=TN(’{REPORT ORDER DETAILS:O.ExactTotal.Sum:(OU=\$1)}') * 0.015]

still no out come help me here coz staff are waiting for commission tonight

Sorry I’m running my own restaurant tonight and there is a basketball game going on so we are very busy. I would just use a calculator and pen until you can figure out the report syntax

2 Likes

Hi guys still not sorted anybody with the idea

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

You can try something like this to format it pretty.

[=F(TN('{REPORT ORDER DETAILS:O.ExactTotal.Sum:(OU=\$1)}')*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

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.

[Sales by User:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.User:(ODI=True):,}