Problem with formula - display results

[#1]

Hi.

I face a problem with a formula.

What I want to achieve:

Display Sum of quantities if date Goods Issue is after date RDD

I have several Sales orders (documents) with different Materials and dates and qties.

My formula:

if([Goods issue]>RDD,(Sum ([conf qty])+Sum ([unconf qty])))

This works if I select one single Sales Order correctly, but not if there is no selection made.

Question:

Is there a special formula to display the Qty of each Material where the Goods Issue date is after RDD date?

Would be great if anybody has a solution for that.

Thanks

Jens

p.s. find attached file

[gandalfgray · Accepted solution]

Hi Jens

Change your formula to this:

Sum(if([Goods issue]>RDD, [conf qty]-[unconf qty], 0))

hth/gg

[#3]

Great, it works fine.

thanks

jens