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

null
    • Paul_Chappell
    • 1 yr ago
    • Reported - view

    Did you try:

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

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Paul Chappell 

      Yes work thanks Paul 馃憤

    • Fred
    • 1 yr 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.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred 馃憤

    • Jacques_TUR
    • 1 yr ago
    • Reported - view

    Or :

    sum((select Line).(Plan_Earned_Act_E + Plan_Earned_Act_P))
    
    • John_Halls
    • 1 yr ago
    • Reported - view

    Great seeing the progression here...

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 6Replies
  • 121Views
  • 5 Following