Trying to show an aggragate amount in an email report

[Eloy_Paredes_He]

Hello there,

I’m trying to show the total of one column using this email template:

This is the error shown from the Audit Log:
“Errors”: “Error: Workflow rule ‘COTIZAR FLETE’ action ‘COTIZAR FLETE’ Body template. Expression ‘[Total Cotización]’ is invalid due to: Unable to find column ‘Total Cotización’.”

I might be missing a simple sintax.
Thanks

[LeventK]

@Eloy_Paredes_Henriqu
You can use SUM(…) expression in your template.

help.appsheet.com

SUM()

Arithmetic sum of list items

[Eloy_Paredes_He]

I just tryed this:

<<SUM::[# de Pedido / Ppto FABRICANTE].[Subtotal 1]>>

I didn´t get an error message from the Audit Log
But I didn´t get the email report.

If I delete this field I get email report.

[Eloy_Paredes_He]

Got it !!
This is the expression I needed.

<<SUM(PEDIDOS[Subtotal 1])>>

Thanks again Levent !

[LeventK]

You’re welcome