Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
sum({<KeyID={1,2,4,5,12},
SaleDate={">=$(=monthstart(Max(SaleDate)))<=$(=Max(SaleDate))"}
>}Quantity)
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