Trying to show an aggragate amount in an email report

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.

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

1 Like

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.

Got it !!
This is the expression I needed.

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

Thanks again Levent !

You’re welcome

1 Like