Set Analysis

[MK25]

Hi,

I have problem with set analysis. I would like to write expression which would sum sales only for last day and would do new result when I select other selection except when I select year, month year or Date in that case shouldn’t show new result.

____

Let vDate = '=Max(Date)';

____

Sum({<Date={"$(vDate)"},[month year],year, Date>}PV)

Any help woud be very appreciated.

[Or]

The second Date in the set analysis needs to be removed - you can't apply two selections to the same field in the same set.

[vikasmahajan]

Hi ,

Have you try following

Sum({$ <Date= { "$( =$(vDate) )" }>}  PV)

thanks

Vikas

[MK25]

If I try Sum({$ <Date= { "$( =$(vDate) )" }>}  PV) I get 0 as a result.

[anat]

Sum({<Date= {"$(=Max(Date))"},[month year]=,year=, Date=>}PV)

[MK25]

If I try this: Sum({<Date={"$(vDate)"},[month year],year >}PV) and select diferent month year or year I get new resoult and that is not OK.

The fields month year and year I get from fild Date:

Date(Monthstart([Date]),'MM-YYYY') as [month year],

[MK25]

Sum({<Date= {"$(=Max(Date))"},[month year]=,year=, Date=>}PV)

Still the same problem, if I select diferent month year or year I get new resoult and that is not OK.

[anat]

Sum({1<Date= {"$(=Max(Date))"},[month year]=,year=, Date=>}PV)

or

Sum({<Date= {"$(=Max({1}Date))"},[month year]=,year=, Date=>}PV)

[MK25]

If I try this: Sum({1<Date= {"$(=Max(Date))"},[month year]=,year=, Date=>}PV) I get always the same result no matter what I select and as result I get sum of all date not just last date.

If I try this: Sum({<Date= {"$(=Max({1}Date))"},[month year]=,year=, Date=>}PV) selection work perfect but again always sum for all date not just last date.