topic Re: Expression gives Negative value for percentage(%)??? in Archived Groups

Expression gives Negative value for percentage(%)???

Wed, 23 Jul 2025 14:48:52 GMT

Hi All,

Here is the expression, It pass through the error check but it gives Negative value as -30%. Please can any one suggest whats wrong with it. There is nothing wrong with the data. It should show me 30% but not -30 %. Thanks

= num((Count(class)-Count({<[student group]={'?'}>}class)*100)/Count(class),'00.00')&'%'

Re: Expression gives Negative value for percentage(%)???

alexandros17 — Wed, 19 Aug 2015 13:58:40 GMT

You are computing Count({<[student group]={'?'}>}class)*100

I think that the Whole difference

Count(class)-Count({<[student group]={'?'}>}class)

should be multiplyed by 100

Let me know

Re: Expression gives Negative value for percentage(%)???

Wed, 19 Aug 2015 14:04:12 GMT

Hi Alessandro

Do you mean I can simply change it to:

=Count(class)-Count({<[student group]={'?'}>}class)*100

Please reply.

Thanks

Re: Expression gives Negative value for percentage(%)???

alexandros17 — Wed, 19 Aug 2015 14:56:47 GMT

No I mean that you are

counting: Count(class)

Minus

Count({<[student group]={'?'}>}class)*100

and this difference can be negative.

Are you multiplying by 100 to compute the percentage?

If the answer is yes then I should write

(Count(class)-Count({<[student group]={'?'}>}class))*100