Expression help

is this expression:

(([T.TotalAmount]-[CA.Discount]-[CA.Discount Fixed]-[EC.Bairros.Taxa]-[EC.Bairros.TaxaExtra])*[EC.Vendedor.Comision]/100).Sum

good for use inside in a report tag?

Can I use the .sum with that calculation?

This:

@{REPORT ENTITY DETAILS:E.Name.asc:(ET=Vendedores)::{0}:,}
[Taxas $1:1, 2, 2, 2]
    {REPORT TICKET DETAILS:T.TicketNumber,[T.TotalAmount]-[CA.Discount]-[CA.Discount Fixed]-[EC.Bairros.Taxa]-[EC.Bairros.TaxaExtra],EC.Vendedor.Comision,(([T.TotalAmount]-[CA.Discount]-[CA.Discount Fixed]-[EC.Bairros.Taxa]-[EC.Bairros.TaxaExtra])*[EC.Vendedor.Comision]/100):(TEN.Vendedor=$1)}
    >Total $1|||{REPORT TICKET DETAILS:(([T.TotalAmount]-[CA.Discount]-[CA.Discount Fixed]-[EC.Bairros.Taxa]-[EC.Bairros.TaxaExtra])*[EC.Vendedor.Comision]/100).Sum:(TEN.Vendedor=$1)}

totals in a blank

Thanks!!!

G.

You can’t. I think sum is for sql query by report tag.
You can’t use it like that.

shut…
seriously???

I tought I may have seen something like that…

G.

Unless I missing something while I away but I don’t think you can use sum anywhere except (some) Report Tag.

Have you tried something like:

(([T.TotalAmount.Sum]-[CA.Discount.Sum]-[CA.Discount Fixed.Sum] ...

that is because I cant see longer than my nose… I have to go to the eye doctor…

THANKS!!!

G.

PS PPPPPPPPPPPPPPRRRRRRRRRRRRRRRRRRRRRRRRRR

Or you can have a nose job.

hey… are you saying that my nose is big???

I would rather prefer other kind of jobs… LOL!!!