B
Blade370
I have a query which is summing one field and counting another. In the 3rd
column I have an expression which takes the sum divide by the count
multiplied by 100 to give an overall percentage. It seems to work fin until i
add a fraction in like 0.5 to the summed field then the percentage doesn't
seem to change to reflect this.
Example 1.5/3*100 = 50% on my query it is still showing as 100% and no
matter what else you add to the summed field it remains like that.
Any Ideas???
Thanks
column I have an expression which takes the sum divide by the count
multiplied by 100 to give an overall percentage. It seems to work fin until i
add a fraction in like 0.5 to the summed field then the percentage doesn't
seem to change to reflect this.
Example 1.5/3*100 = 50% on my query it is still showing as 100% and no
matter what else you add to the summed field it remains like that.
Any Ideas???
Thanks