Morning,
Can somebody please tell me how I can get the system to treat this as 1 number so I can use it to calculate an average in reports.
{REPORT TICKET DETAILS:TT.Covers.sum:(DE=Bistro) AND (TY=Bistro Food)} + {REPORT ORDER COUNT:(MT.Takeaway Dish Count=1) AND (TY=Bistro Food) AND (DE=Surfside Breakfast)}
The above values return 4 + 5
But for example if I want to use this to create an average from 100.
I need it to treat it as 100 / 9 (the total of the above)
but instead it does the following 100/4+5 giving me 30 as the answer
the answer I would expect should be 11.11
Sorry I am new to all this I’m doing ok but I keep getting stuck at things that probably seem so simple.
You guys are fantastic.
regards
Craig