How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
Locked
How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
 
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
Administrator
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
Administrator
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
Administrator
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
Administrator
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
|
Hi Alex,
For example: length of service if type of position = 1 we have here : 3 (2+1) (manager is in two lines) length of service if type of position = 2 we have here: 0 (no specialists)
--  and here ( I changed manager into specialist in second row): length of service if type of position = 1 we have here : 3 (but manager is now in only in first line, so it should change into 2) length of service if type of position = 2 we have here: 3 (specialists in second row, , so it should change into 1) length of service if type of position =1 and sector = 1,2,3,4,5 - we have here: 3 (but manager is now in only in first line, so it should change into 2)  Formulas there: in the third field of the Calculations section: sum( $length_service_control[ string() castable as xs:decimal and ../../..//type_position = '1' ], 0.0 ) in the fourth field of the Calculations section: sum( $length_service_control[ string() castable as xs:decimal and ../../..//type_position = '2' ], 0.0 ) in the fifth field of the Calculations section: sum( $length_service_control[ string() castable as xs:decimal and ../sector_control = ('1', '2', '3', '4', '5') and ../../..//type_position = '1' ], 0.0 ) środa, 17 lutego 2021 o 20:54:01 UTC+1 Alessandro Vernet napisał(a): Hi Vlad, You received this message because you are subscribed to the Google Groups "Orbeon Forms" group. To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email]. To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/4232497d-1c11-4691-a0d5-adbdbf685797n%40googlegroups.com. |
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
Administrator
|
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
|
HI Alex, Thank you suggestions. Nesting is the keyword ;) When I started comparing the form (because mine was more complex than what I presented here, it turned out that I also had a repeteted grid between the main grid and type of position (so the type of position was in a completely different grid). And that's why I probably had problems with the calculations. As I moved the type of position to the main grid, it started to count properly. In a case like here, it seems to me that: ../../..//type_position = '1' doesn't count properly and ../type_position = '1' also  And by the way, is it possible in Orbeon to place a repeted grid in a grid, or an ordinary grid in a grid (like nesting grids) ? czwartek, 18 lutego 2021 o 07:11:56 UTC+1 Alessandro Vernet napisał(a): Hi Vlad, You received this message because you are subscribed to the Google Groups "Orbeon Forms" group. To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email]. To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/d57461b0-c2f0-478d-8c44-4d79796f0021n%40googlegroups.com. |
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
|
Here is example with repeated grid between: https://demo.orbeon.com/demo/fr/orbeon/builder/edit/64354b46f04d18097299ae3e657328e23ca0f401
grid-2//type_position = '1' doesn't count properly I read here: https://www.w3schools.com/xml/xpath_syntax.asp bookstore//book - Selects all book elements that are descendant of the bookstore element, no matter where they are under the bookstore element czwartek, 18 lutego 2021 o 10:23:02 UTC+1 Władysław Czaja napisał(a):
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group. To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email]. To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/2293bd9c-da2b-4997-85f6-880b3728a8d7n%40googlegroups.com. |
Re: How to add up the values in rows repeated grid / section depending on checkbox / radio button selection in another control, but on the same row?
|
Administrator
|
| Free forum by Nabble | Edit this page |