Skip to Content
0
Former Member
Feb 21, 2011 at 05:46 AM

Formula creation in Query designer

31 Views

Hi All

I want to explain a bit more on my requirement .

I have supplied qty and ordered qty and i have the difference between both which is called as service level as %. there will always be 100% for some suppliers and lessthan 100% . So i want to count only the 100% suppliers and divide by all the suppliers . so that i can get the perfect order . and the formula is below .

I need to apply a formula line count with 100% / line count in one of my querys how to do it the qury designer . Can you anybody guide how to do it .

Thanks in advance . I am sorry if i have posted in the worng fourm .

thanks