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
  • Newest first
  • Active threads
  • 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
      • 1 mth ago
      • Reported - view

      Paul Chappell 

      Yes work thanks Paul 馃憤

      Like
    • Fred
    • Fred
    • 1 mth 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
      • 1 mth ago
      • Reported - view

      Fred 馃憤

      Like
  • Or :

    sum((select Line).(Plan_Earned_Act_E + Plan_Earned_Act_P))
    
    Like 1
  • Great seeing the progression here...

    Like
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 6Replies
  • 40Views
  • 5 Following