How to create report for calculating waiter salary 10% from user sale? I tried following code but it doesn’t work:
[=F({REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum}) * 0.1]
Your missing single quotes around report tag.
You mean like this? [=F(’{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum}’) * 0.1]. Doesn’t work
You can’t use O.User in it. It’s giving a string back. You need to only return a number in the expression.
how can i get int from there?
There is an old topic regarding user sales, it might not be exactly what you need but might guide you in the right direction.
Is this purely a report? Not in automation flow?
Even if the first field was a number it still wouldnt work, you wouldnt be able to have more than one field.
Logically your result would be;
[=Field1,Field*0.1]
Which makes no sense,
What I expect you want is something like this;
{REPORT ORDER DETAILS:O.User,=[O.ExactTotal.Sum]*0.1}
Thank you for your reply. Unfortunately, it also doesn’t work. It shows 0 on user sales
What doesnt work, show what your doing.
You need to use expression calculations. You can find how to do that in the reports section of kb.sambapos.com
That’s not correct syntax please read the reports section of kb I linked to learn how to do field calculations.
Thank you. i read that instruction and all works fine with following statement
[Waiter Salary 10%:1, 1]
{REPORT ORDER DETAILS:O.User,=[O.ExactTotal.sum]/10}
1 Like