0

WBS Sum budget elements

@Fred

Hello Fred I'm developing a fairly large WBS with 5 levels, I'm using the cascade method, I have a problem with the formula sum of the Budbet of each element of the WBS.

The WBS is not complete yetis ready Engineering, Procurement a half and Construction complete.

This formula don't work is on WBS table 

sum((select DOCUMENTS).Presupuesto like Level_1 = 1)

7 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    The "like Level_1 = 1" is not something that will work in Ninox.

    Are you trying to find like or equal? You can't do both.

    Then you need to put the filter next to the table name using the square brackets [ ].

    sum((select DOCUMENTS)[Level_1 like 1].Presupuesto)
    or
    sum((select DOCUMENTS)[Level_1 = 1].Presupuesto)
    
      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred 

      Hi Fred 

      The Formula give me error Field not found Level_1 馃様

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

      Fred 

      Hi Fred 

      The Formula give me error Field not found Level_1 馃様

      sum((select DOCUMENTS)['Level 2' = 2].Presupuesto)

      This work but give me  always 0.00  even if the WBS Level change.

    • Fred
    • 1 yr ago
    • Reported - view

    I thought Presupuesto is a field name. If it is a reference field to a table then you can change the code to:

    sum((select DOCUMENTS)[Presupuesto.Level_1 like 1].fieldname)
    or
    sum((select DOCUMENTS)[Presupuesto.Level_1 = 1].fieldname)
    
      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred 

      Level_1 is on WBS and Level 1 is on Documents.

    • Fred
    • 1 yr ago
    • Reported - view

    Remember that when dealing with dynamic choice fields you are working with record Id when you select a choice. You can show the Id field in the table view of the WBS table to see the record Id of each record.

    or since these are dynamic choice fields you can use text:

    sum((select DOCUMENTS)[text('Level 2') = "Procura"].Presupuesto)
    
      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred 

      Dear 馃憤thanks a lot.

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 7Replies
  • 52Views
  • 2 Following