help me write this expression

[#1]

Could you help me write:

sum of cen_Class_Data where d_DistanceApart_Miles is LESS THAN OR EQUAL TO varMaxDist? I'm really struggling here.

[#2 · Accepted solution]

Try something like this:

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

[jagan]

Hi,

Try this

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

Hope this helps you.

Regards,

Jagan.