Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
For your example:
='Total .: '&Num(Sum(Sales),'#.##0,00')
Is possible the format are diferent
Saludos,
Enrique Colomer
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')
For your example:
='Total .: '&Num(Sum(Sales),'#.##0,00')
Is possible the format are diferent
Saludos,
Enrique Colomer
Perfecto!
I mean perfecto here!
TX
GRACIAS
Hi David
You just have to use '&' inbetween your Total and Sum expression. See the example:
'Total : '&SUM(Sales)
Regards
Aviral Nag