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
-
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)-
Fred
Hi Fred
The Formula give me error Field not found Level_1
-
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.
-
-
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)-
Fred
Level_1 is on WBS and Level 1 is on Documents.
-
-
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)-
Fred
Dear
thanks a lot.
-
Content aside
- Status Answered
- 2 yrs agoLast active
- 7Replies
- 56Views
-
2
Following