egghelp/eggheads community

calculate % between two rows

2007-02-06T14:24:32-04:00

Using braces in expr is faster so I'd recommend using the first option.

Statistics: Posted by metroid — Tue Feb 06, 2007 2:24 pm

calculate % between two rows

2007-02-05T15:38:13-04:00

% format %.2f 2.85714285714
2.86

Edit: user did include that in his code

Statistics: Posted by Sir_Fz — Mon Feb 05, 2007 3:38 pm

calculate % between two rows

2007-02-05T06:25:31-04:00

ok that works, thanks.

Final question

the output now looks like for example:

2.85714285714 %

Is it possible it wil only announce the first one or two after the "." ?

So someting like:

2.85 %

And thanks for all the help

Statistics: Posted by heman — Mon Feb 05, 2007 6:25 am

calculate % between two rows

2007-02-05T06:08:25-04:00

add the ".0" to your static value (100) or remove the braces...

Code:

% set a 3; set b 7% format %.2f [expr {($a*100.0)/$b}]42.86% format %.2f [expr ($a.0*100)/$b]42.86

Statistics: Posted by user — Mon Feb 05, 2007 6:08 am

calculate % between two rows

2007-02-05T05:44:55-04:00

ok that works, sort of.

cnupdt = 7
cnt =175

7 x 100 / 175 = 4 so it announces -> 4

cnupdt = 5
cnt =175

5 x 100 / 175 = 2,86 but it announces -> 2

Is there a way it announce -> 2,86 ?

http://www.tcl.tk/man/tcl8.4/TclCmd/expr.htm

expr 5 / 4

returns 1, while

expr 5 / 4.0

return 1.25

I tried

Code:

set perc [expr {($cnupdt.0*100)/$cnt}]instead ofset perc [expr {($cnupdt*100)/$cnt}]

But that didnt worked.

Statistics: Posted by heman — Mon Feb 05, 2007 5:44 am

calculate % between two rows

2007-02-04T20:08:46-04:00

Yup, type conversion and order of operations.
With tcl, if you divide two integers, the result will also be an integer (using truncation). And since percent is less than 1, you'll always get 0.

You'll either have to do the multiplication first, or convert the numbers to floats (I'd say the first is easier)

Try this:

Code:

set perc [expr {($cnupdt*100)/$cnt}]

Statistics: Posted by nml375 — Sun Feb 04, 2007 8:08 pm

calculate % between two rows

2007-02-04T19:14:57-04:00

I tried

Code:

set perc [expr { $cnupdt / $cnt * 100 }]

but results is : 0

Am I missing something?

Statistics: Posted by heman — Sun Feb 04, 2007 7:14 pm

calculate % between two rows

2007-02-03T16:41:57-04:00

You probably would like to investigate the expr command.

Statistics: Posted by nml375 — Sat Feb 03, 2007 4:41 pm

calculate % between two rows

2007-02-03T15:00:52-04:00

I have to colums: "nm" and "update"

To count the inputs i use the folowing codes:

Code:

set cnt [mysqlsel $db "select count(*) from $table WHERE nm = '$text';" -list]set cnupdt [mysqlsel $db "select count(*) from $table WHERE update = '$text';" -list]

This gives announcemnet liek this:

100 releases in db, 50 are updated

Now I want to make a variable that will tell the percentage updates are made from nm

Someting like:

100 releases in db, 50 are updated (50%)

Thanks

Statistics: Posted by heman — Sat Feb 03, 2007 3:00 pm