Troubleshooting Select Statement

[Bill_Bounds]

I have a list of Jobs that each have a number of days they will take to complete. I am trying to sum the [Days to Complete] column for the records that have a [Product_Sort_Number] less than the current record.

This is the expression I am using
sum(SELECT(Products[days to complete],[Product_Sort_Number]< [_THISROW].[Product_Sort_Number]))

any suggestions appreciated.

[Steve]

In what way doesn’t it give you the result you want?

[Bill_Bounds]

It’s the Jen B row that’s miscalculating.

Thanks for your thoughts Steve.

[Marc_Dillon]

Is [CalcDaysBefore] a Virtual or Real column? Expressions in Real columns don’t evaluate until that record is edited in some way.

[Bill_Bounds]

Thanks for the suggestion. I think there was a duplicate reference number and because the real columns did not update it was showing mixed results in the output. Anyway it seems to be working now with some conversion to virtual columns. Much appreciated definitely got me on the right track.