[SOLVED] Mathematical Calculation Fields

Are there any plugins to calculate mathematical formula or conditions.

For example cb_fieldnumbers = cb_number01 + cb_number02

Something like Microsoft Excel?

You'd need to use CB Query Field so you can use MySQL functions to add, subtract, etc.. Example as follows.

I am actually trying to do a BMI Calculator for my members.

The formula is based on the following: www.nutriweb.org.my/bmical.php

Krileon, I am quite a beginner on this. Is CB Query field something downloadable by Professional members (or do I create it at the CB Field Management Function)? Or is it just the delimiter field?

The formula is based on the following: www.nutriweb.org.my/bmical.php

That's a simple formula that MySQL can certainly do assuming you've weight and height fields. Example query as follows.

Is CB Query field something downloadable by Professional members

Yes, it's downloaded from the Professional downloads section.

or do I create it at the CB Field Management Function?

Once downloaded and installed, yes it's a new fieldtype so it's created via CB > Field Management.

Thanks for the reply! Really appreciate it.

Now, I am using the cb conditional plugin to show a delimiter field "you are over weight" if the BMI is over 30.

Somehow cb conditional is showing "you are overweight" even though it is less then 30.. is it because that CB conditional is not be able to detect the value since its a cb query field?

Another thing is that when i get the results from such query, the decimal points are set to 14 points. example: 22.4765868886576

CB Conditional may not work properly with query fields. It expects the field to actually have stored value. So you'll probably need to use a IF substitution in your delimiter field.

[cb:if cb_query>="30"]You appear to be over weight![/cb:if]

Another thing is that when i get the results from such query, the decimal points are set to 14 points. example: 22.4765868886576

You need to use additional SQL functions to format it as needed. You can find the documentation for MySQL as follows.

dev.mysql.com/doc/refman/5.6/en/index.html

More specifically numeric functions as follows.

dev.mysql.com/doc/refman/5.6/en/numeric-functions.html