Summing a calculated multi part Expression

[suepenick]

When I use this expression it works

StdCost * (Sum(if (SaleType='Pontoons', QtyShipped)))

but when I want to Total it, it will not work

SUM ( StdCost * (Sum(if (SaleType='Pontoons', QtyShipped))))

any Ideas?

[#2]

test the next just add sum the first expression:

sum(StdCost) * (Sum(if (SaleType='Pontoons', QtyShipped)))

regards!!!!

[#3 · Accepted solution]

Or this way

Sum (if (SaleType='Pontoons', QtyShipped*StdCost))

[Sokkorn]

Hi Penick,

Did you try below script yet?

Sum({$<SaleType = {'Pontoons'}>} StdCost*QtyShipped)

Regards,

Sokkorn

[suepenick]

This one made the total go into the billions.

[suepenick]

Thanks!  You can't even know how many different ways I tried to make this work.  and then I look at your solution and want to slap myself on the forehead!   Thanks so much