Calculate BMI (body mass index) in form

Plipp

Hello,

MY QUESTION: I have two formfields "weight (kg)" and "height (m)" and i want to calculate "BMI" (body mass index) using the formula "kg / m^2".

BEST is, the "BMI" value is a new field, because i want to group and sort all the data using Calc.
I read about problems about this but did not understand it, yet.
Is it possible?

Thank you so much!
Plipp

PS: i use an OOO Base MySQL database with a linux OS. I connect to the database using ODBC.
The OOO database is easy to handle and i already have lots of data.
_________________
OOo 3.0 Ubuntu 9.04

RPG · Posted: Mon Oct 12, 2009 7:27 am Post subject:

Hello

Your question is not clear.

I think make query and import the values you need in OOo-calc.
That is not a form.

Romke

Plipp · Posted: Mon Oct 12, 2009 9:36 am Post subject: third field

my idea was:

i have a form with two fields: weight (kg) + height (m) where i put in my data.
there is a third field below, where the result is calculated automatically.

is this possible?
sorry for the unclear question.

thank you very much.
Plipp
_________________
OOo 3.0 Ubuntu 9.04

RPG · Posted: Mon Oct 12, 2009 10:24 am Post subject:

Hello

When you input data in a form then you can not get a calculated result in the same form.
Form fields must be connected with a field in a table. A calculated field does not have a connection to a field so you have a problem.
So I think it is not possible in an easy way and I don't know a solution

Romke

r4zoli · Posted: Mon Oct 12, 2009 10:42 am Post subject:

Add a subform to the form, add textbox to subform and as datasource use query which calculates BMI.

Villeroy · Posted: Mon Oct 12, 2009 10:59 am Post subject:

Forms don't calculate anything, but they can be used to display results calculated in queries.

Calculating a volume from 3 numbers ("horizontal calculation" across 3 fields): http://user.services.openoffice.org/en/forum/download/file.php?id=1266

Calculating aggregations for grouped categories ("vertical calculation" within fields): http://user.services.openoffice.org/en/forum/download/file.php?id=2950
_________________
XUbuntu 9.04, OOo 3.1.1(Sun), Sun Java 1.5.0_06

Plipp · Posted: Mon Oct 12, 2009 11:50 am Post subject: display query results

I will try this and i think this will solve my problem.

thank you.
great work as usual! Very Happy

_________________
OOo 3.0 Ubuntu 9.04