Calculation

I want to average 5 scores into a new score.

In Excel I would do this:

=(A1+A2+A3+A4+A5)/5

``

In XLSForm I tried this, but it didn’t work

(${A1}+${A2}+${A3}+${A4}+${A5})/5

``

Any suggestions

Hi.

The value that goes in the xlsform compiles to an xpath, which uses its own operators. (Presumably it’s to avoid conflicting with the “/” in the /path/of/an/xpath .)

I’d give this a try next:

···

On Tue, Aug 30, 2016 at 9:45 PM, Johnny Knox knoxj...@gmail.com wrote:

I want to average 5 scores into a new score.

In Excel I would do this:

=(A1+A2+A3+A4+A5)/5

``

In XLSForm I tried this, but it didn’t work

(${A1}+${A2}+${A3}+${A4}+${A5})/5

``

Any suggestions

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

Alex Dorey
415.886.7537

Great it worked! Thanks so much!