Calculation in script

[nareshthavidishetty]

Hi ,

We need to calculated an logic in edit script.Please find below.

Logic:

sum(ESIGN_COMPLETE_NEW)/sum(ToTAL_ORDERS_DAILY_NEW)

Script:

A:

LOAD A7AJCD,

     A7AACD,

     A7AIDT,

     ESIGN_COMPLETE_NEW,

     APA0TX

FROM

[F\QVD\Marketing\eSign\Daily_eSign.qvd]

(qvd);

B:

LOAD A7AJCD,

     A7AACD,

     A7AIDT,

     TOTAL_ORDERS_DAILY_NEW,

     APA0TX

FROM

[FQVD\Marketing\eSign\Daily_Total.qvd]

(qvd);

Thanks..

[vishsaggi]

May be this?

A:

LOAD A7AJCD,

     A7AACD,

     A7AIDT,

     ESIGN_COMPLETE_NEW,

     APA0TX

FROM

[F\QVD\Marketing\eSign\Daily_eSign.qvd]

(qvd);

Concatenate(A)

B:

LOAD A7AJCD,

     A7AACD,

     A7AIDT,

     TOTAL_ORDERS_DAILY_NEW,

     APA0TX

FROM

[FQVD\Marketing\eSign\Daily_Total.qvd]

(qvd);

C:

LOAD A7AJCD,

     A7AACD,

     A7AIDT,

     APA0TX, Sum(ESIGN_COMPLETE_NEW)/Sum(TOTAL_ORDERS_DAILY_NEW) AS NewTotals

Resident A

GROUP BY A7AJCD, A7AACD, A7AIDT, APA0TX;

DROP TABLE A;