| help about the Report [message #88518] |
Sat, 26 October 2002 01:51  |
Sarita
Messages: 7
Registered: June 2002
|
Junior Member |
|
|
my project name is vendor rating query in Data model
select
a.po_no,a.po_date,a.icode,b.iname, a.qty,D.QTY,
d.del_sch,e.doc_no,e.doc_dt,e.qty_rcpt, E.QTY, C.QTY
from
po_order a,
invmast b,
sch_ord d,
mrrstor e,
REJ_NOTE C,
rej_det f
where
a.po_no= e.po_no and a.po_date=e.po_date and a.icode=b.icode
and d.po_no=a.po_no and d.po_date=a.po_date and
f.mrr_no= e.doc_no and f.mrr_dt=e.doc_dt and
c.doc_no=f.doc_no and c.doc_dt=f.doc_dt
In a Formula Coloumn in query CF_1 am using the formula is :return :del_sch-:po_date;
Cf_2 am using the formula is return :doc_dt - :po_date;
the formula i Want to use in this type of format
Quality Rating (QR) = Qty.Accepted Q.A Deptt
_______________________ * 100
Qty Supplied
Delivery Rating (DR) = Q1 T
____ * ____________ * 100
Q T8P=1.5*T1*q
where (P) = (ACT_DEl_Qty) Q1
_________________
(Sch_Del_qty) Q
(Q) = 1-p
How to use this format of formula in my form 6 report
|
|
|
|
| Re: help about the Report [message #88521 is a reply to message #88518] |
Sun, 27 October 2002 22:51  |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
Hi,
its little bit confussion here because exactly i am not understanding what you want, like you want do to in the report all these calculation Or what ?
second thing :- why you mentioned CF_1 and CF_2 means what you are trying to tell....
Third thing :- You have written some fomula for Quality Rating like (QR),Qty.Accepted Q.A Deptt,Qty Supplied. i want to know these thing are there in the Query or not if it is there then what is the column names..
same thing for Delivery Rating also......
Can you post the Query in a more clear way... Or if i am wrong then pls. correct me.......
Regards,
Ravi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
