LinkedIn
Twitter
Evening,
Iโm trying to SUM() a list with a Number type VC expression and I donโt get why it isnโt workingโฆ
- This expression returns a list of two rows (22 & 36)
The value of [cms_estimate] in row 22 is 5
The value of [cms_estimate] in row 36 is 6
MIN(
SELECT(
survey[_RowNumber],
AND(
[lcs] = [_THISROW].[lcs],
[select_cabinet_to_survey] = [_THISROW].[select_cabinet_to_survey],
[survey_number] = [_THISROW].[survey_number]
))
)
- Iโm trying to SUM() the [cms_estimate] column rows so I pin this to the front:
SUM(
SELECT(
survey[cms_estimate],
[_RowNumber] =
...
)
)
- but the following gives me an answer of zero when Iโm expecting to see eleven
SUM(
SELECT(
survey[cms_estimate],
[_RowNumber] =
MIN(
SELECT(
survey[_RowNumber],
AND(
[lcs] = [_THISROW].[lcs],
[select_cabinet_to_survey] = [_THISROW].[select_cabinet_to_survey],
[survey_number] = [_THISROW].[survey_number]
))
)
)
)
Please could someone point out what Iโm doing wrongโฆ?.. Cheersโฆ 
Solved
1 ACCEPTED SOLUTION
Hi @GreenFlux,
Hole-in-one! That did the trickโฆ! Many thanksโฆ 
SUM(
SELECT(
survey[cms_estimate],
[_RowNumber] =
MIN(
SELECT(
survey[_RowNumber],
AND(
[lcs] = [_THISROW-1].[lcs],
[select_cabinet_to_survey] = [_THISROW-1].[select_cabinet_to_survey],
[survey_number] = [_THISROW-1].[survey_number]
))
)
)
)
.
.
Cheersโฆ
