Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to calculate the sum of sales at the last day of each week
I have used the flags :
if(match([weekday],6) or CAL.K_DATE=today(),1,0) as flag_week in my KPI table
and i used a set analysis if flag_week ={'1'} in the expression
My issue is Exaample:
if the date is tuesday = not the end of the week i should concider this date as my week end since date of today < end of the week
My current expression does not show me the same result of set analysis with 'if last_analysis_date={'yes'}
Where is the issue and is my set analysis correct ?
How are you creating last_analysis_date?
in Calandar from my data model
Okay, that make sense. So, you want an expression where you use both last_analysis_date and flag_week in an expression? And when you do use them, what issue do you run into?