Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I wonder if someone can help I currently have an expression that sums the weight based on the delivery year which is set in a variable however I want to filter this data to only display anything bigger than 450,000
this is my current expression : sum({$<DYear = {$(#vYear1)}>} Weight)
thanks in advance
J
May be this:
If(Sum({$<DYear = {$(#vYear1)}>} Weight) > 450000, Sum({$<DYear = {$(#vYear1)}>} Weight))
May be this:
If(Sum({$<DYear = {$(#vYear1)}>} Weight) > 450000, Sum({$<DYear = {$(#vYear1)}>} Weight))
sum({$<DYear = {$(#vYear1)} , Weight={'>450000'}>} Weight)
try if sum should be greater than 450000
if (sum({$<DYear = {$(#vYear1)}>} Weight) >450000, sum({$<DYear = {$(#vYear1)}>} Weight))
or if every weight should be more than 450000
sum({$<DYear = {$(#vYear1)},Weight={'>=450000'}>} Weight)