Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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) +
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)
)
You are missing closing >} within e()
I tried adding the closing >} and have the same results
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