Set Analysis Filter

[#1]

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

[sunny_talwar · Accepted solution]

May be this:

If(Sum({$<DYear = {$(#vYear1)}>} Weight) > 450000, Sum({$<DYear = {$(#vYear1)}>} Weight))

[tresB]

sum({$<DYear = {$(#vYear1)} , Weight={'>450000'}>} Weight)

[Anonymous]

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)