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)

6replies Oldest first
• Oldest first
• Popular
• Did you try:

sum((select Line).Plan_Earned_Act_E) + sum((select Line).Plan_Earned_Act_P)

Like 1
• Rafael
• Rafael Sanchis
• Rafael_Sanchis
• 2 mths ago
• Reported - view

Paul Chappell

Yes work thanks Paul

Like
• Fred
• Fred
• 2 mths ago
• Reported - view

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.

Like 3
• Rafael
• Rafael Sanchis
• Rafael_Sanchis
• 2 mths ago
• Reported - view

Fred

Like
• Or :

``````sum((select Line).(Plan_Earned_Act_E + Plan_Earned_Act_P))
``````
Like 1
• John Halls
• John_Halls
• 2 mths ago
• Reported - view

Great seeing the progression here...

Like
Like Follow