Want to change a text property of a text box to include the sum of a column

[#1]

Hi, I have a text object and I would like it to say 'Total:' and then the sum of a column I have, like Sales. How can I have 'Total:' then followed by the SUM(Sales)?

Thanks!

[ecolomer]

Here you have an example:

=Num(Sum(if(TipoDocumento='Factura' AND [Año Documento]=$(AnyoActual), [Importe linea],if(TipoDocumento='Abono'   AND [Año Documento]=$(AnyoActual), [Importe linea],0))),'#.##0,00 €')

Another example:

='Días Transcurridos = '&Num(ReloadTime()-MakeDate($(AnyoActual),01,01),'#.##0 días')

[ecolomer · Accepted solution]

For your example:

='Total .: '&Num(Sum(Sales),'#.##0,00')

Is possible the format are diferent

Saludos,

Enrique Colomer

[#4]

Perfecto!

[#5]

I mean perfecto here!

[ecolomer]

TX

GRACIAS

[aveeeeeee7en]

Hi David

You just have to use '&' inbetween your Total and Sum expression. See the example:

'Total : '&SUM(Sales)

Regards

Aviral Nag