A summary in date range for specific weekday

[jacek_stypulkow]

Hi,

can you advice on the below please:

I have to find the summary of the items in date range, but just for all Tuesday in that range.

I have used two conditions in my expression. Each of them worked perfectly fine as individual expression.

The below summary worked for date range:

sum({<Date={">=$(=Date(AddMonths( MonthStart (Today()),0),'YYYY-MM-DD hh:mm:ss.ffffff'))<$(=Date(Today(),'YYYY-MM-DD hh:mm:ss.ffffff'))"}>} Items)

The below summary worked for Tuesdays:

sum({<Date={"=weekday(Date)='Tue'"}>} Items)

but when I got them combined as below the date range is ignored resulting the summary for Tuesdays only

sum({<Date={">=$(=Date(AddMonths( MonthStart (Today()),0),'YYYY-MM-DD hh:mm:ss.ffffff'))<$(=Date(Today(),'YYYY-MM-DD hh:mm:ss.ffffff'))"}, Date={"=weekday(Date)='Tue'"}>} Items)

Can you help to resolve it?

Regards

Jacek

[maxgro]

try with * 

count({$ <Date={">=01/01/2023"}*{"<=31/10/2023"}*{"=weekday(Date)='mar'"}>} Date)

[jacek_stypulkow]

It's not resolved an issue directly but inspired me to find another working solution, thanks Maxgro.