Extracting future PO Deliveries

[#1]

sum({$<[Purchase Required Date]={">=$(=Now())">}[Purchase Ordered FC Value])

What is wrong with this expression?

I am attempting to sum all PO's with a required delivery date greater than today.

thank you!

[tamilarasu]

Hi Craig,

You missed Paranthesis

=sum({$<[Purchase Required Date]={">=$(=Date(today(),'DD/MM/YYYY'))"}>}[Purchase Ordered FC Value])

Change the data format according to the Purchase Required Date format.

Let me know.

[jonas_rezende]

Hi, Craig.

The Now() function

returns a timestamp of the current time from the system clock. Ex.: 11/13/2015 11:06:45

So, you have of format for date. Use function Date(). Ex.:

sum({$<[Purchase Required Date]={">=$(=Date(Now()))">}[Purchase Ordered FC Value])

Hope this helps!

[#4]

Unfortunately I am still doing something wrong. My data looks like this without the filtering:

Purchase Required Date

Purchase Order Num

Item Group

Item Code

03/01/2016

46727

Foil

00047X24

17340

03/01/2016

46728

Foil

00045X2350 8079

14859

02/18/2016

45825

Misc Supplies

Misc

920

02/15/2016

46472

Foil

0004X2450 8079

61180

My expression is:

=sum({$<[Purchase Required Date]={">=$(=Date(Now()))">}[Purchase Ordered FC Value])

I believe I have attached the file.

Any suggestions?

[maxgro · Accepted solution]

=sum({$<[Purchase Required Date]={">=$(=Date(Now()))"}>} [Purchase Ordered FC Value])

[#6]

Thank you.  That was the answer.