Date selection in Multi box generating incorrect o/p

[#1]

Hi Team,

I have an application where user has option to select Date, and on selection I have to show MTD,QTD, YTD till selected date,but if there is no sale for that particular date then nulls are coming which results into incorrect values. This is the expression I am using

sum({<KeyID={1,2,4,5,12},

SaleDate={">=$(=monthstart(GetFieldSelections(SaleDate)))<=$(=GetFieldSelections(SaleDate))"}

>}Quantity)

SaleDate is in Multibox which user selects.

Please help.

Regards,

Navdeep

[tresesco]

Try like:

sum({<KeyID={1,2,4,5,12},

SaleDate={">=$(=monthstart(Max(SaleDate)))<=$(=Max(SaleDate))"}

>}Quantity)

[#3]

Hi,

Tried it, but no success, now nothing is showing up for the dimension values which don't have sales for selected date.

Can I use some variable using calendar object ?

Regards,

Navdeep