Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can I write this things:
= If((YEAR(JWX) *100 + Week(JWX))<=Year(Addmonths(Today(1),-1) )*100 + Week(Addmonths(Today(1),-1)),Sum({<ORT={'C sonstige Orten'}>*<(YEAR(JWX) *100 + Week(JWX))={"<=$(=(Year(Addmonths(Today(1),-1) )*100 + Week(Addmonths(Today(1),-1)))) " }>} TOTAL BLEGW),Sum({<ORT={'C sonstige Orte'}>}BLEGW))
Hi,
I'm not really sure about the expression purpose, but if JWX is a field in your data model, yes, you can use it inside Year and Week function, if JWX holds number values.
Hi, in the same table where JWX is (or in a calendar table) you can create a field like:
YEAR(JWX) *100 + Week(JWX) as YearWeek
And use YearWeek field in set analysis
better to create a field in load script by using the same logic then call that field in set expression.
YEAR(JWX) *100 + Week(JWX) as Week_field
= If(Week_field<=Year(Addmonths(Today(1),-1) )*100 + Week(Addmonths(Today(1),-1)),Sum({<ORT={'C sonstige Orten'}>*<Week_field={"<=$(=(Year(Addmonths(Today(1),-1) )*100 + Week(Addmonths(Today(1),-1)))) " }>} TOTAL BLEGW),Sum({<ORT={'C sonstige Orte'}>}BLEGW))
thanks you