Expression in syntax

[#1]

Hello,

I am using this expression Date={"=Max(LoginDate)"} and its not working...

Can anybody help to make it correct??

[its_anandrjs]

Try to use like

Date ={'$(=Max(LoginDate))'}

Or

Date ={"$(=Max(LoginDate))"}

Eg:-

Sum({<Date ={'$(=Max(LoginDate))'}>} ConstrumValue)

[CELAMBARASAN]

Try this

Date={'$(=Date(Max(LoginDate)))'}

Your expression will be kind of below

Sum({<Date={'$(=Date(Max(LoginDate)))'}>} Sales)

[#4]

Anand,

not working....

[#5]

not working adhimulam

[#6]

hey navneet this expression wont work as u r comparing date with max of date and in the seletction you will have year and month

so rather you should write expression as following

Sum({<Year={"$(=max(Date_Year))"},Month={"$(=max(Date_Month))"}>}sales)

try like this

[anbu1984]

can you show your app?

[CELAMBARASAN]

Is your Date field has the same format which is specified in DateFormat variable?

[its_anandrjs]

Check the date format for fields  Date  and  LoginDate    that should be same in format.

[its_anandrjs]

See the below example for the same problem

LOAD Date(TranDate,'MM/DD/YYYY') AS TranDate,Sales;

LOAD * Inline

[

TranDate,Sales

1/1/2014,3343

1/2/2014,454

1/3/2014,65

1/4/2014,64767

1/5/2014,7676

1/6/2014,7767

1/7/2014,7676

1/8/2014,7676

1/9/2014,767434

1/10/2014,767

];

Dimension:- TranDate

Expression:- Sum({<TranDate ={'$(=Max(TranDate))'}>} Sales)

The result will be  767 for max date 1/10/2014