0
sum((select......... with two values
Hi, I try to use this formula but don't work
sum((select Line).Plan_Earned_Act_E;
Plan_Earned_Act_P) or
sum((select Line).Plan_Earned_Act_E +
Plan_Earned_Act_P)
6 replies
-
Did you try:
sum((select Line).Plan_Earned_Act_E) + sum((select Line).Plan_Earned_Act_P)
-
Paul Chappell
Yes work thanks Paul
-
-
Or you can do:
let x := (select Line) sum(x.Plan_Earned_Act_E) + sum(x.Plan_Earned_Act_P)For this formula the two selects won't make a big difference, but just to get into the habit of limiting the use of select statements.
-
Fred
-
-
Or :
sum((select Line).(Plan_Earned_Act_E + Plan_Earned_Act_P)) -
Great seeing the progression here...
Content aside
- Status Answered
- 2 yrs agoLast active
- 6Replies
- 173Views
-
5
Following