How to make an array with totals ?

Hi,

With the 2018.1 version, I look at the possibilities of the builder compared
to what you manually develop as a form.
And there is a need that does not seem to me covered by the builder: a
number chart with totals on the last line.

Our clients manage finances, and they need a table for entering financial
amounts and automatic totals at the end of the line.
I tried to do a repeat grid, but you can not include a footer with a total.

Is there another possibility?
Thank You.

julien

--
Sent from: http://discuss.orbeon.com/

--
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 post to this group, send email to [hidden email].

Hi Julien,

If you have a repeated grid which contains an (repeated) input field named
`price`, you can have a field outside of the repeated grid that computes the
total with the expression `sum($price)`. If there is a chance that some
values aren't number (e.g. left empty) and you want to treat those as zeros,
you'll write the following (for more on this, see the link below):

sum($price[string() castable as xs:decimal], 0.0)

Is this inline with what you're looking for?

https://doc.orbeon.com/form-builder/formulas/formulas-examples#sum-of-values-in-a-repeat

-Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
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 post to this group, send email to [hidden email].

Hi Alex,

I did not see the example in doc. I was wondering if there was a component to do that. Because the rendering is not as good as if it was a footnote.
It's basically what I did, but how does the variable $price work? it's just the fact of putting a "price" id on the input fields? and $price gives access to the data? you do not have to build the xpath?

Thank You.

julien

-----Message d'origine-----
De : [hidden email] <[hidden email]> De la part de Alessandro Vernet
Envoyé : jeudi 20 septembre 2018 02:27
À : [hidden email]
Objet : [orbeon] Re: How to make an array with totals ?

Hi Julien,

If you have a repeated grid which contains an (repeated) input field named `price`, you can have a field outside of the repeated grid that computes the total with the expression `sum($price)`. If there is a chance that some values aren't number (e.g. left empty) and you want to treat those as zeros, you'll write the following (for more on this, see the link below):

sum($price[string() castable as xs:decimal], 0.0)

Is this inline with what you're looking for?

https://doc.orbeon.com/form-builder/formulas/formulas-examples#sum-of-values-in-a-repeat

-Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
Sent from: http://discuss.orbeon.com/

--
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 post to this group, send email to [hidden email].

--
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 post to this group, send email to [hidden email].

--
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 post to this group, send email to [hidden email].

--
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 post to this group, send email to [hidden email].

--
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 post to this group, send email to [hidden email].