Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write an expression to calculate number of sales on first specific weekday (Monday) of month/Quarter?
try something like this using weekday function.
if( weekday(month)='monday', count(sales),null())
if( weekday(month_number)='monday', count(sales),null())
Hi Shree,
thanks for reply.I want to calculate only for first monday of each month/Quarter.
Hi
Try like this
=if(Day(Date) <= 7 and WeekDay(Date) = 'Mon',Sum(Sales))
May be that helps