set analyse won't work

[#1]

Hi,

Why doesn't this work?

=sum({$<DateShouldBeSend={'<=$(=Max(SelectedDates))'},DateItHasBeenSend={'>=$(=Min(SelectedDates))'} >} hours)

table1

order number

DateShouldBeSend

DateItHasBeenSend

hours

table2

week

year

SelectedDates

there is no connection between table 1 and table 2.

[#2]

Oh it seems DateShouldBeSend and DateItHasBeenSend  where not the same date format.

needed to do Date(DateShouldBeSend,'DD-MM-YYYY') as DateShouldBeSend,

[#3]

You may try this small change in syntax:

=sum({$<DateShouldBeSend={"<=$(='Max(SelectedDates)')"},DateItHasBeenSend={">=$(='Min(SelectedDates)')"} >} hours)

Regards,

Murali

[jagan · Accepted solution]

Hi,

Check whether all the date dimensions are in the same date format.  That may be the problem.

Regards,

Jagan.