Exclude(E) function

[jjking58]

Can someone tell me why this would not work?

I've researched this on the community site and everything looks correct, but i'm not getting any results in my table

Thanks in advance

[sergio0592]

Try with :

sum( {$<fYear =,CustomerName= E({1<ProductName={‘BASEBALL PRO’}>})>} PartsAmt) +

sum( {$<fYear =,CustomerName= E({1<ProductName={‘BASEBALL PRO’}>})>} EqupAmt) +

sum( {$<fYear =,CustomerName= E({1<ProductName={‘BASEBALL PRO’}>})>} LaborAmt) +

[vishsaggi]

Try this:

= Rangesum(0, Sum({<fYear=, CustomerName = E({1< ProductName = {'BASEBALL PRO'}) >} PartsAmt),

                          Sum({<fYear=, CustomerName = E({1< ProductName = {'BASEBALL PRO'}) >} EqupAmt),

                          Sum({<fYear=, CustomerName = E({1< ProductName = {'BASEBALL PRO'}) >} LaborAmt)

                     )

[sunny_talwar]

You are missing closing >} within e()

[jjking58]

I tried adding the closing >} and have the same results

[jjking58]

I found the problem i changed sum({$ to sum({1 and the number appeared. I was excluding customers based on the current selection

Thanks both for the quick response