Problem with formula - display results

Thu, 01 Sep 2011 11:42:11 GMT

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

Re: Problem with formula - display results

gandalfgray — Thu, 01 Sep 2011 12:04:55 GMT

Hi Jens

Change your formula to this:

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

hth/gg

Thu, 01 Sep 2011 12:07:21 GMT

Great, it works fine.

thanks

jens