sum/%

Hi,

i have 2 count came from two queries

s1: 20

s2: 50

i want to find the % but my synstax didn't work, is there other way besides evaluate function?

thanks

This topic has been closed for replies.

Inspiring

In addition to isaac's answer, make sure you protect yourself from division by zero errors.

Inspiring

kt03 wrote:
<cfset percent = (s1/s2) * 100 />

This does not work for you?

There should be NO reason to use evaluate for what you want to do.

You MAY need to use more of the full record set syntax. I.E. variable.column[row] OR variable["column"][row].

Sign up