Set Analysis

[shamitshah]

Hi ,

Please see attached.

I am trying to get today's sales figure and the year to date sales figure in a text box, but not getting any result with the current expression.

So, if today's date is 23 Jan 2017, the figure for today's sales should be 1,000 and the year to date figure should be 314,044

Any idea where I am going wrong?

Thanks

[sushil353 · Accepted solution]

Hi,

Just change your environmental variable as

SET DateFormat='DD-MMM-YY';

SET TimestampFormat='DD-MMM-YY h:mm:ss[.fff] TT';

and expression :

='$'&num(SUM({<Date={"$(=date(vDisplayDate,'DD-MMM-YY'))"}>}Sales),'#,##0','.',',')

YTD: ='$'&num(SUM({<Date={"<=$(=date(vDisplayDate,'DD-MMM-YY'))"}>}Sales),'#,##0','.',',')

HTH

Sushil

[Anil_Babu_Samineni]

Try to change env variables, Becuase you have DD-MMM-YY Format. But Date gave only DD-MM-YYYY

[shamitshah]

Thanks Sushil.

[shamitshah]

Thanks Anil.