How do i calculate order Qty

[#1]

Dear All,

             I have one small query on my report, my query is how do i calculate Order Qty if Pending Qty is not equal to Zero.

I have two expressions in my report

1) Order Qty

2) Pending Qty

Order Qty -  Order Qty wher pending Qty is not zero.

Pending Qty - Order Qty - Sales Qty.

Please find attached excel sheet.

Regards,

Napolean.

[swuehl]

I think this should work:

Create a straight table with dimension Quote_No,

Use two expressions:

=if([Pending Qty]>0,[Order Qty])

and

=[Pending Qty]

Check suppress zero values in presentation tab.

Regards,

Stefan

edited:

second expression field

edited by swuehl

[#3]

Hi,

        Pending qty is not a field name, it is an expression name.

Pending Qty = Order Qty - Sales Qty.

Regards,

Napolean.

[swuehl]

I was referring to your excel file (and I can't see a Sales Qty there), but anyway, just replace [Pending Qty] by ([Order Qty]- [Sales Qty])

Stefan

[#5]

Hi,

  Chk ths

-Jai

[#6]

Hi,

      i tried in straight table but its not working....

=if(([Order Qty]- [Sales Qty])>0,[Order Qty])

Regards,

Napolean.

[swuehl]

Do you have more than one record per Quote_No? Could you update your excel file with more detailed data then, including the sales data?

[#8]

you'll need to change that to a sum

=Sum(if(([Order Qty]- [Sales Qty])>0,[Order Qty]))