0

Sum the value of the result field from table1 when the value of deportment is "1"

Hello

The table has a result field and a department field. The department field takes its value from another table from Choise filde, value of 1 2 or 3

Need a formula to calculate the result, depending on the importance of the department.

For example, sum the value of the result field from table1 when the value of deportment is "1"

4 replies

null
    • Fred
    • 2 mths ago
    • Reported - view

    is this formula in the same table or in another table?

    If another table, are they related?

      • iliper LTD
      • iliper_LTD
      • 2 mths ago
      • Reported - view

       Hi

      Another table,  'finaly Estimation' 

      There is table 'finaly Estimation'  and in it there is a subtable 'estimation' . field 'Departmennt'  and 'result' located  'estimation'

      • Fred
      • 2 mths ago
      • Reported - view

      Try:

      sum(estimation[Departmennt = 1].result)
      
      • iliper LTD
      • iliper_LTD
      • 2 mths ago
      • Reported - view

       Excellent, thank you very much

Content aside

  • Status Answered
  • 2 mths agoLast active
  • 4Replies
  • 41Views
  • 2 Following