Lost in calculations lol


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.



100/{REPORT TICKET DETAILS:TT.Covers.sum:(DE=Bistro)} + {REPORT TICKET DETAILS:TT.Covers.sum:(TY=Bistro Food)} + {REPORT ORDER COUNT:(MT.Takeaway Dish Count=1)} + {REPORT ORDER COUNT:(TY=Bistro Food)} + {REPORT ORDER COUNT: (DE=Surfside Breakfast)} ?

I’m not 100% sure on how calculations work but never know lol

Something like this;
[= TN( ' { EXPRESSION1 } ' ) + TN( ' { EXPRESSION2 } ' )]