set analysis filter

[sunil1989]

Hi,

Can anyone help me with below expression

=Sum({<BookedDeliveryDateKey = {=Num#(Date(Today(),'YYYYMMDD'))}>}Item_Volume)

Thanks,

Sunilkumar

[prma7799]

Try like this

{"(=Num#(Date(Today(),'YYYYMMDD')))"}

or

{"(=Date(Today(),'YYYYMMDD'))"}

[sunil1989]

Tried but its not working

[Kushal_Chawda]

this should be like below

=Sum({<BookedDeliveryDateKey = {"$(=Date(Today(),'YYYYMMDD'))"}>}Item_Volume)

if it's not working then check the Format of BookedDeliveryDateKey. You need to provide the same format in set analysis.