set expression help. Select where less than variable

[#1]

Hi.

This is what I have so far.

Sum({$<d_DistanceApart_Miles={">=0<varMaxDist"}>}cen_Class_Data)

I am trying to sum the field cen_Class_Data

WHERE d_DistanceApart_Miles is LESS THAN varMaxDist (Which is a variable I have set)

Any clues why my set expression isn't working? It doesn't seem to be updating when I change my variable.

[#2 · Accepted solution]

try this

Sum({$<d_DistanceApart_Miles={">=0<$(=varMaxDist)"}>}cen_Class_Data)

[#3]

You are a QV Wizard, thank you.