I just completed the customization for a client. Testing was also done successfully, however, I need help with this report template. I want to be able to display the total of sales in percentages as follows:
- Vendor percentage to equal 70% of total sales of specific menu item for given period.
- Commission percentage to equal 30% of total sales of specific menu item for given period.
i formulated my report using some tips i found here on the forum, it is giving me the percentage of total sales including other menu items.
This is my template below:
@BEER
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:|}
[$1 Sales:8, 2, 2,2,2]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O…Sum.desc:(ODI=True) and O.MenuItemName=“$2” and (MG=$1)}
{REPORT ORDER DETAILS:’ '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$2” and (MG=$1) and O.PortionName!=“Normal”}Total Sales|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) and (MG=$1)}
@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,}
[Sharing Formula:1, 1, 1]
Vendor Sales: |[=F(TN(“{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}”)*0.7)]
Commission: |[=F(TN(“{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}”)*0.3)]