Basic Set Analysis

[dberkesacn]

Hi Guys,

pls help me in this simple set analysis, =sum({<Date={">2017.02.01"}>}Value), why this is not working?

Would like to filter the date - global date format in the begging of the script is SET DateFormat='YYYY.MM.DD';.

Thanks,

D

[prma7799]

Please check date format

=sum({<Date={">01.03.2017"}>}Sales_Total )

This is working in my app.

[MK_QSL]

What is the format of your Date field?

[#4]

try to use date format of your "Date" data field in set comparision.

[Frank_Hartmann]

what format has your "Date" field?

maybe:

sum({<Date={'>2017.02.01'}>}Value)

hope this helps

[dberkesacn]

it come from the initial global variable SET DateFormat='YYYY.MM.DD'; and the source data has also this structure.

[prma7799]

Could you please share some sample app

[sasikanth]

HI

Try this

=SUM({<Date={"> $(=num(Dat#( '2017.02.01','YYYY.02.01'))) "}>}Value)

[dberkesacn]

Yes.

[Frank_Hartmann]

see attached file

hope this helps