add two fields from different tables

[arulsettu]

hi

i need to add two fields from different tables. and check with condition like values > 0  and display it in chart for current month

any suggestions ?

[anbu1984]

Are your tables joined in script? What do you want to do if diff is greater than 0?

Can you post your sample qvw

[arulsettu]

can i send to your mail id?

[sorrakis01]

hi,

can you upload the project?

[arulsettu]

here it is

InvoiceQty from invoice table

QtyOrdered from orders table

add this two fields and check with condition (qtyordered – qtyshipped)  (check if result is > zero)

thanks

[arulsettu]

any help