Format an equation in reports

V5 Question
1

Is there any way to format like #.00
this expression:
[=TN('{REPORT ORDER DETAILS:O.Quantity.Sum:(MG=Pizza) AND O.PortionName="Familia"}') + TN('{REPORT ORDER DETAILS:O.Quantity.Sum:(MG=Pizza Entera) AND O.PortionName="Familia"}') + TN('{REPORT ORDER DETAILS:O.Quantity.Sum:(MG=Pizza) AND O.PortionName="Grande"}') + TN('{REPORT ORDER DETAILS:O.Quantity.Sum:(MG=Pizza Entera) AND O.PortionName="Grande"}') + TN('{REPORT ORDER DETAILS:O.Quantity.Sum:(MG=Calzone)}')/3]

in order to get the report with 2 decimals?

Pasted image1366×768 44.3 KB

thanks!!!

G.

2

Yes, wrap the entire thing inside F():

F(<allyourstuff>)         // by default, with no format specified, uses 2 decimals
F(<allyourstuff>,'#.00')  // forcing 2 decimals

F(Newbie)

1 Like
3

completely forgot about that!!!

thanks!!!

G.