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.
In what way doesnโt it give you the result you want?
Itโs the Jen B row thatโs miscalculating.
Thanks for your thoughts Steve.
Is [CalcDaysBefore] a Virtual or Real column? Expressions in Real columns donโt evaluate until that record is edited in some way.
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.
User | Count |
---|---|
35 | |
31 | |
30 | |
20 | |
17 |